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

TABLE: GML.GML_GPOAO_DETAIL_ALLOCATIONS_X

Object Details
Object Name: GML_GPOAO_DETAIL_ALLOCATIONS_X
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.GML_GPOAO_DETAIL_ALLOCATIONS_X
Subobject Name:
Status: VALID


GML_GPOAO_DETAIL_ALLOCATIONS_X is the extension table for GML_GPOAO_DETAIL_ALLOCATIONS. There is a one to one relationship between the two tables linked by the Transaction Record ID.
The extension table is available for transaction customization and allows supplemental data from a non-Oracle data source to be written to the outbound files.
Refer to the Oracle EDI Gateway Users Guide, Extensible EDI Gateway Architecture section for instructions on how to customize an EDI transaction.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_RECORD_ID NUMBER

Transaction Record ID
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
REQUEST_ID NUMBER (15)
Standard Who Column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who Column
PROGRAM_ID NUMBER (15)
Standard Who Column
PROGRAM_UPDATE_DATE NUMBER (15)
Standard Who Column
Query Text

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


SELECT TRANSACTION_RECORD_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM GML.GML_GPOAO_DETAIL_ALLOCATIONS_X;

Dependencies

[top of page]

GML.GML_GPOAO_DETAIL_ALLOCATIONS_X does not reference any database object

GML.GML_GPOAO_DETAIL_ALLOCATIONS_X is referenced by following:

SchemaAPPS
SynonymGML_GPOAO_DETAIL_ALLOCATIONS_X