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

TABLE: GML.GML_GPOAO_ORDER_TEXT

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


GML_GPOAO_ORDER_TEXT contains order header text data to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP)).
This table is based primarily on data stored in the OP_TEXT_TBL table in OPM Order Fulfillment.
All columns denoted with an "INT" or "Internal" represent Oracle Applications internal values. All columns with "EXT" or "External" represent the equivalent external values sourced from the ECE_XREF_DATA table if code conversion is enabled for the column.
Each row in the GML_GPOAO_ORDER_TEXT is purged after the data is written to the data file.
TRANSACTION_RECORD_ID is the unique key that links the GML_GPOAO_ORDER_TEXT table to its corresponding extension table GML_GPOAO_ORDER_TEXT_X.


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

Transaction Run ID
ORDER_ID NUMBER

Sales Order ID
LANG_CODE_INT VARCHAR2 (4)
Language Code (Int)
LANG_CODE_EXT1 VARCHAR2 (10)
Language Code (Ext1)
LANG_CODE_EXT2 VARCHAR2 (10)
Language Code (Ext2)
LANG_CODE_EXT3 VARCHAR2 (10)
Language Code (Ext3)
LANG_CODE_EXT4 VARCHAR2 (10)
Language Code (Ext4)
LANG_CODE_EXT5 VARCHAR2 (10)
Language Code (Ext5)
PARA_CODE_INT VARCHAR2 (4)
Paragraph Code (Int)
PARA_CODE_EXT1 VARCHAR2 (10)
Paragraph Code (Ext1)
PARA_CODE_EXT2 VARCHAR2 (10)
Paragraph Code (Ext2)
PARA_CODE_EXT3 VARCHAR2 (10)
Paragraph Code (Ext3)
PARA_CODE_EXT4 VARCHAR2 (10)
Paragraph Code (Ext4)
PARA_CODE_EXT5 VARCHAR2 (10)
Paragraph Code (Ext5)
SUB_PARACODE NUMBER

Sub Paragraph Code
LINE_NO NUMBER

Text Line Number
TEXT VARCHAR2 (80)
Free Form Text
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 RUN_ID
,      ORDER_ID
,      LANG_CODE_INT
,      LANG_CODE_EXT1
,      LANG_CODE_EXT2
,      LANG_CODE_EXT3
,      LANG_CODE_EXT4
,      LANG_CODE_EXT5
,      PARA_CODE_INT
,      PARA_CODE_EXT1
,      PARA_CODE_EXT2
,      PARA_CODE_EXT3
,      PARA_CODE_EXT4
,      PARA_CODE_EXT5
,      SUB_PARACODE
,      LINE_NO
,      TEXT
,      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_ORDER_TEXT;

Dependencies

[top of page]

GML.GML_GPOAO_ORDER_TEXT does not reference any database object

GML.GML_GPOAO_ORDER_TEXT is referenced by following:

SchemaGML
ViewGML_GPOAO_ORDER_TEXT#