Relationships Between The Various Database Objects

This image shows one table, APPS Schema, next to several smaller vertically lined-up tables. The APPS Schema table contains several groups of letters. Arrows from these letters point to each of the smaller tables to the right.

Legend: S=Synonym, V=View, T=Table

APPS Schema - Group 1
S ® T AOL
S ® T AOL
S ® T GL
S ® T GL
S ® T GL
S ® T FA
S ® T FA
S ® T FA

APPS Schema - Group 2
S ® T AP

APPS Schema - Group 3
S ® T AP
V ® T AP
S ® T PO

APPS Schema - Group 4
V ® T PO
S ® T PO

APPS Schema - Group 5
V ® T AR
V ® T AR
S ® T AR

APPS Schema - Group 6
V ® T OM

APPS Schema - Group 7
S ® T OM
S ® T OM

APPS Schema - Group 8
V ® T PA
V ® T PA
S ® T PA

APPS Schema - Group 9
S ® T INV
S ® T INV
S ® T INV
S ® T BOM
S ® T BOM
S ® T BOM

APPS Schema - Group 10
S ® T WIP
S ® T WIP
S ® T WIP

APPS Schema - Group 11
S ® T MRP
S ® T MRP
S ® T MRP

APPS Schema - Group 12
S ® T CRP
S ® T CRP
S ® T CRP

Return to document