DBA Data[Home] [Help] [Dependency Information]

TABLE: PO.PO_LINE_LOCATIONS_ALL_EXT_B

Object Details
Object Name: PO_LINE_LOCATIONS_ALL_EXT_B
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_LINE_LOCATIONS_ALL_EXT_B
Subobject Name:
Status: VALID


This table stores the data for User Defined Attributes linked to the Purchase Order / Agreement / Modification Schedule. Corresponding to each Purchase Order / Agreement / Modification Schedule record, there will be one record per attribute group associated for single row Attribute groups. For multi row attribute groups (such as addresses) there will be one record per row of the multi row attribute group. Extension_id (sequence generated) is the primary key for the table. For single row attribute groups, the combination of line_location_id, draft_id and attribute_group_id will also be unique. For multi row attribute groups, the uniqueness will be on line_location_id, draft_id, attribute_group_id + the database columns which map to the attributes which are part of the unique key for that attribute group.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_LINE_LOCATONS_ALL_EXT_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_LOCATION_ID
ColumnDRAFT_ID
ColumnATTR_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
EXTENSION_ID NUMBER
Yes EXTENSION_ID
ATTR_GROUP_ID VARCHAR2 (30) Yes Stores the ATTR_GROUP_ID of the attribute group
LINE_LOCATION_ID NUMBER
Yes LINE_LOCATION_ID
DATA_LEVEL_ID NUMBER

Stores Data Level ID.
PK1_VALUE NUMBER

PK1_VALUE
PK2_VALUE NUMBER

PK2_VALUE
PK3_VALUE NUMBER

PK3_VALUE
PK4_VALUE NUMBER

PK4_VALUE
PK5_VALUE NUMBER

PK5_VALUE
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
C_EXT_ATTR1 VARCHAR2 (4000)
C_EXT_ATTR1
C_EXT_ATTR2 VARCHAR2 (4000)
C_EXT_ATTR2
C_EXT_ATTR3 VARCHAR2 (4000)
C_EXT_ATTR3
C_EXT_ATTR4 VARCHAR2 (4000)
C_EXT_ATTR4
C_EXT_ATTR5 VARCHAR2 (4000)
C_EXT_ATTR5
C_EXT_ATTR6 VARCHAR2 (4000)
C_EXT_ATTR6
C_EXT_ATTR7 VARCHAR2 (4000)
C_EXT_ATTR7
C_EXT_ATTR8 VARCHAR2 (4000)
C_EXT_ATTR8
C_EXT_ATTR9 VARCHAR2 (4000)
C_EXT_ATTR9
C_EXT_ATTR10 VARCHAR2 (4000)
C_EXT_ATTR10
C_EXT_ATTR11 VARCHAR2 (4000)
C_EXT_ATTR11
C_EXT_ATTR12 VARCHAR2 (4000)
C_EXT_ATTR12
C_EXT_ATTR13 VARCHAR2 (4000)
C_EXT_ATTR13
C_EXT_ATTR14 VARCHAR2 (4000)
C_EXT_ATTR14
C_EXT_ATTR15 VARCHAR2 (4000)
C_EXT_ATTR15
C_EXT_ATTR16 VARCHAR2 (4000)
C_EXT_ATTR16
C_EXT_ATTR17 VARCHAR2 (4000)
C_EXT_ATTR17
C_EXT_ATTR18 VARCHAR2 (4000)
C_EXT_ATTR18
C_EXT_ATTR19 VARCHAR2 (4000)
C_EXT_ATTR19
C_EXT_ATTR20 VARCHAR2 (4000)
C_EXT_ATTR20
C_EXT_ATTR21 VARCHAR2 (4000)
C_EXT_ATTR21
C_EXT_ATTR22 VARCHAR2 (4000)
C_EXT_ATTR22
C_EXT_ATTR23 VARCHAR2 (4000)
C_EXT_ATTR23
C_EXT_ATTR24 VARCHAR2 (4000)
C_EXT_ATTR24
C_EXT_ATTR25 VARCHAR2 (4000)
C_EXT_ATTR25
C_EXT_ATTR26 VARCHAR2 (4000)
C_EXT_ATTR26
C_EXT_ATTR27 VARCHAR2 (4000)
C_EXT_ATTR27
C_EXT_ATTR28 VARCHAR2 (4000)
C_EXT_ATTR28
C_EXT_ATTR29 VARCHAR2 (4000)
C_EXT_ATTR29
C_EXT_ATTR30 VARCHAR2 (4000)
C_EXT_ATTR30
C_EXT_ATTR31 VARCHAR2 (4000)
C_EXT_ATTR31
C_EXT_ATTR32 VARCHAR2 (4000)
C_EXT_ATTR32
C_EXT_ATTR33 VARCHAR2 (4000)
C_EXT_ATTR33
C_EXT_ATTR34 VARCHAR2 (4000)
C_EXT_ATTR34
C_EXT_ATTR35 VARCHAR2 (4000)
C_EXT_ATTR35
C_EXT_ATTR36 VARCHAR2 (4000)
C_EXT_ATTR36
C_EXT_ATTR37 VARCHAR2 (4000)
C_EXT_ATTR37
C_EXT_ATTR38 VARCHAR2 (4000)
C_EXT_ATTR38
C_EXT_ATTR39 VARCHAR2 (4000)
C_EXT_ATTR39
C_EXT_ATTR40 VARCHAR2 (4000)
C_EXT_ATTR40
N_EXT_ATTR1 NUMBER

N_EXT_ATTR1
N_EXT_ATTR2 NUMBER

N_EXT_ATTR2
N_EXT_ATTR3 NUMBER

N_EXT_ATTR3
N_EXT_ATTR4 NUMBER

N_EXT_ATTR4
N_EXT_ATTR5 NUMBER

N_EXT_ATTR5
N_EXT_ATTR6 NUMBER

N_EXT_ATTR6
N_EXT_ATTR7 NUMBER

N_EXT_ATTR7
N_EXT_ATTR8 NUMBER

N_EXT_ATTR8
N_EXT_ATTR9 NUMBER

N_EXT_ATTR9
N_EXT_ATTR10 NUMBER

N_EXT_ATTR10
N_EXT_ATTR11 NUMBER

N_EXT_ATTR11
N_EXT_ATTR12 NUMBER

N_EXT_ATTR12
N_EXT_ATTR13 NUMBER

N_EXT_ATTR13
N_EXT_ATTR14 NUMBER

N_EXT_ATTR14
N_EXT_ATTR15 NUMBER

N_EXT_ATTR15
N_EXT_ATTR16 NUMBER

N_EXT_ATTR16
N_EXT_ATTR17 NUMBER

N_EXT_ATTR17
N_EXT_ATTR18 NUMBER

N_EXT_ATTR18
N_EXT_ATTR19 NUMBER

N_EXT_ATTR19
N_EXT_ATTR20 NUMBER

N_EXT_ATTR20
UOM_EXT_ATTR1 VARCHAR2 (3)
UOM_EXT_ATTR1
UOM_EXT_ATTR2 VARCHAR2 (3)
UOM_EXT_ATTR2
UOM_EXT_ATTR3 VARCHAR2 (3)
UOM_EXT_ATTR3
UOM_EXT_ATTR4 VARCHAR2 (3)
UOM_EXT_ATTR4
UOM_EXT_ATTR5 VARCHAR2 (3)
UOM_EXT_ATTR5
UOM_EXT_ATTR6 VARCHAR2 (3)
UOM_EXT_ATTR6
UOM_EXT_ATTR7 VARCHAR2 (3)
UOM_EXT_ATTR7
UOM_EXT_ATTR8 VARCHAR2 (3)
UOM_EXT_ATTR8
UOM_EXT_ATTR9 VARCHAR2 (3)
UOM_EXT_ATTR9
UOM_EXT_ATTR10 VARCHAR2 (3)
UOM_EXT_ATTR10
UOM_EXT_ATTR11 VARCHAR2 (3)
UOM_EXT_ATTR11
UOM_EXT_ATTR12 VARCHAR2 (3)
UOM_EXT_ATTR12
UOM_EXT_ATTR13 VARCHAR2 (3)
UOM_EXT_ATTR13
UOM_EXT_ATTR14 VARCHAR2 (3)
UOM_EXT_ATTR14
UOM_EXT_ATTR15 VARCHAR2 (3)
UOM_EXT_ATTR15
UOM_EXT_ATTR16 VARCHAR2 (3)
UOM_EXT_ATTR16
UOM_EXT_ATTR17 VARCHAR2 (3)
UOM_EXT_ATTR17
UOM_EXT_ATTR18 VARCHAR2 (3)
UOM_EXT_ATTR18
UOM_EXT_ATTR19 VARCHAR2 (3)
UOM_EXT_ATTR19
UOM_EXT_ATTR20 VARCHAR2 (3)
UOM_EXT_ATTR20
D_EXT_ATTR1 DATE

D_EXT_ATTR1
D_EXT_ATTR2 DATE

D_EXT_ATTR2
D_EXT_ATTR3 DATE

D_EXT_ATTR3
D_EXT_ATTR4 DATE

D_EXT_ATTR4
D_EXT_ATTR5 DATE

D_EXT_ATTR5
D_EXT_ATTR6 DATE

D_EXT_ATTR6
D_EXT_ATTR7 DATE

D_EXT_ATTR7
D_EXT_ATTR8 DATE

D_EXT_ATTR8
D_EXT_ATTR9 DATE

D_EXT_ATTR9
D_EXT_ATTR10 DATE

D_EXT_ATTR10
UDA_TEMPLATE_ID NUMBER
Yes UDA_TEMPLATE_ID
DRAFT_ID NUMBER

DRAFT_ID
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXTENSION_ID
,      ATTR_GROUP_ID
,      LINE_LOCATION_ID
,      DATA_LEVEL_ID
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      C_EXT_ATTR1
,      C_EXT_ATTR2
,      C_EXT_ATTR3
,      C_EXT_ATTR4
,      C_EXT_ATTR5
,      C_EXT_ATTR6
,      C_EXT_ATTR7
,      C_EXT_ATTR8
,      C_EXT_ATTR9
,      C_EXT_ATTR10
,      C_EXT_ATTR11
,      C_EXT_ATTR12
,      C_EXT_ATTR13
,      C_EXT_ATTR14
,      C_EXT_ATTR15
,      C_EXT_ATTR16
,      C_EXT_ATTR17
,      C_EXT_ATTR18
,      C_EXT_ATTR19
,      C_EXT_ATTR20
,      C_EXT_ATTR21
,      C_EXT_ATTR22
,      C_EXT_ATTR23
,      C_EXT_ATTR24
,      C_EXT_ATTR25
,      C_EXT_ATTR26
,      C_EXT_ATTR27
,      C_EXT_ATTR28
,      C_EXT_ATTR29
,      C_EXT_ATTR30
,      C_EXT_ATTR31
,      C_EXT_ATTR32
,      C_EXT_ATTR33
,      C_EXT_ATTR34
,      C_EXT_ATTR35
,      C_EXT_ATTR36
,      C_EXT_ATTR37
,      C_EXT_ATTR38
,      C_EXT_ATTR39
,      C_EXT_ATTR40
,      N_EXT_ATTR1
,      N_EXT_ATTR2
,      N_EXT_ATTR3
,      N_EXT_ATTR4
,      N_EXT_ATTR5
,      N_EXT_ATTR6
,      N_EXT_ATTR7
,      N_EXT_ATTR8
,      N_EXT_ATTR9
,      N_EXT_ATTR10
,      N_EXT_ATTR11
,      N_EXT_ATTR12
,      N_EXT_ATTR13
,      N_EXT_ATTR14
,      N_EXT_ATTR15
,      N_EXT_ATTR16
,      N_EXT_ATTR17
,      N_EXT_ATTR18
,      N_EXT_ATTR19
,      N_EXT_ATTR20
,      UOM_EXT_ATTR1
,      UOM_EXT_ATTR2
,      UOM_EXT_ATTR3
,      UOM_EXT_ATTR4
,      UOM_EXT_ATTR5
,      UOM_EXT_ATTR6
,      UOM_EXT_ATTR7
,      UOM_EXT_ATTR8
,      UOM_EXT_ATTR9
,      UOM_EXT_ATTR10
,      UOM_EXT_ATTR11
,      UOM_EXT_ATTR12
,      UOM_EXT_ATTR13
,      UOM_EXT_ATTR14
,      UOM_EXT_ATTR15
,      UOM_EXT_ATTR16
,      UOM_EXT_ATTR17
,      UOM_EXT_ATTR18
,      UOM_EXT_ATTR19
,      UOM_EXT_ATTR20
,      D_EXT_ATTR1
,      D_EXT_ATTR2
,      D_EXT_ATTR3
,      D_EXT_ATTR4
,      D_EXT_ATTR5
,      D_EXT_ATTR6
,      D_EXT_ATTR7
,      D_EXT_ATTR8
,      D_EXT_ATTR9
,      D_EXT_ATTR10
,      UDA_TEMPLATE_ID
,      DRAFT_ID
FROM PO.PO_LINE_LOCATIONS_ALL_EXT_B;

Dependencies

[top of page]

PO.PO_LINE_LOCATIONS_ALL_EXT_B does not reference any database object

PO.PO_LINE_LOCATIONS_ALL_EXT_B is referenced by following:

SchemaPO
ViewPO_LINE_LOCATIONS_ALL_EXT_B#