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

TABLE: GML.GML_GASNO_ORDERS

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


GML_GASNO_ORDERS contains key order data that the shipment generated from to support the edi outbound transaction GASNO (OPM Outbound Advanced Ship Notice (856/DESADV)). The order information in this table is based primarily on data stored in the OP_ORDR_HDR table of OPM Order Fulfillment.
All columns denoted with an "INT" represent Applications internal values. All columns with "EXT" represent the equivalent external values.
Each row in the GML_GASNO_ORDERS is purged after the data is written to the data file.


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

Run Id
ORDER_ID NUMBER

Surrogate key for order
ORDER_STATUS NUMBER

The status of order
CUSTPO_NO VARCHAR2 (22)
Customer purchase order number
ORDER_NO VARCHAR2 (32)
Order number assigned by either system or user
SO_ORGN_CODE VARCHAR2 (4)
Organization code
ORDER_COMMENT VARCHAR2 (80)
Comments for order
SO_DATE DATE

Date that order was placed
SO_HEADER_CATEGORY VARCHAR2 (30)
Order header attribute category
SO_HEADER_ATTRIBUTE1 VARCHAR2 (240)
Order header attribute 1
SO_HEADER_ATTRIBUTE2 VARCHAR2 (240)
Order header attribute 2
SO_HEADER_ATTRIBUTE3 VARCHAR2 (240)
Order header attribute 3
SO_HEADER_ATTRIBUTE4 VARCHAR2 (240)
Order header attribute 4
SO_HEADER_ATTRIBUTE5 VARCHAR2 (240)
Order header attribute 5
SO_HEADER_ATTRIBUTE6 VARCHAR2 (240)
Order header attribute 6
SO_HEADER_ATTRIBUTE7 VARCHAR2 (240)
Order header attribute 7
SO_HEADER_ATTRIBUTE8 VARCHAR2 (240)
Order header attribute 8
SO_HEADER_ATTRIBUTE9 VARCHAR2 (240)
Order header attribute 9
SO_HEADER_ATTRIBUTE10 VARCHAR2 (240)
Order header attribute 10
SO_HEADER_ATTRIBUTE11 VARCHAR2 (240)
Order header attribute 11
SO_HEADER_ATTRIBUTE12 VARCHAR2 (240)
Order header attribute 12
SO_HEADER_ATTRIBUTE13 VARCHAR2 (240)
Order header attribute 13
SO_HEADER_ATTRIBUTE14 VARCHAR2 (240)
Order header attribute 14
SO_HEADER_ATTRIBUTE15 VARCHAR2 (240)
Order header attribute 15
SO_HEADER_ATTRIBUTE16 VARCHAR2 (240)
Order header attribute 16
SO_HEADER_ATTRIBUTE17 VARCHAR2 (240)
Order header attribute 17
SO_HEADER_ATTRIBUTE18 VARCHAR2 (240)
Order header attribute 18
SO_HEADER_ATTRIBUTE19 VARCHAR2 (240)
Order header attribute 19
SO_HEADER_ATTRIBUTE20 VARCHAR2 (240)
Order header attribute 20
SO_HEADER_ATTRIBUTE21 VARCHAR2 (240)
Order header attribute 21
SO_HEADER_ATTRIBUTE22 VARCHAR2 (240)
Order header attribute 22
SO_HEADER_ATTRIBUTE23 VARCHAR2 (240)
Order header attribute 23
SO_HEADER_ATTRIBUTE24 VARCHAR2 (240)
Order header attribute 24
SO_HEADER_ATTRIBUTE25 VARCHAR2 (240)
Order header attribute 25
SO_HEADER_ATTRIBUTE26 VARCHAR2 (240)
Order header attribute 26
SO_HEADER_ATTRIBUTE27 VARCHAR2 (240)
Order header attribute 27
SO_HEADER_ATTRIBUTE28 VARCHAR2 (240)
Order header attribute 28
SO_HEADER_ATTRIBUTE29 VARCHAR2 (240)
Order header attribute 29
SO_HEADER_ATTRIBUTE30 VARCHAR2 (240)
Order header attribute 30
TRANSACTION_RECORD_ID NUMBER

Unique identifier which links this table to its associated extension table
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
ORDER_STATUS_CODE VARCHAR2 (16)
The status code for order
Query Text

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


SELECT RUN_ID
,      ORDER_ID
,      ORDER_STATUS
,      CUSTPO_NO
,      ORDER_NO
,      SO_ORGN_CODE
,      ORDER_COMMENT
,      SO_DATE
,      SO_HEADER_CATEGORY
,      SO_HEADER_ATTRIBUTE1
,      SO_HEADER_ATTRIBUTE2
,      SO_HEADER_ATTRIBUTE3
,      SO_HEADER_ATTRIBUTE4
,      SO_HEADER_ATTRIBUTE5
,      SO_HEADER_ATTRIBUTE6
,      SO_HEADER_ATTRIBUTE7
,      SO_HEADER_ATTRIBUTE8
,      SO_HEADER_ATTRIBUTE9
,      SO_HEADER_ATTRIBUTE10
,      SO_HEADER_ATTRIBUTE11
,      SO_HEADER_ATTRIBUTE12
,      SO_HEADER_ATTRIBUTE13
,      SO_HEADER_ATTRIBUTE14
,      SO_HEADER_ATTRIBUTE15
,      SO_HEADER_ATTRIBUTE16
,      SO_HEADER_ATTRIBUTE17
,      SO_HEADER_ATTRIBUTE18
,      SO_HEADER_ATTRIBUTE19
,      SO_HEADER_ATTRIBUTE20
,      SO_HEADER_ATTRIBUTE21
,      SO_HEADER_ATTRIBUTE22
,      SO_HEADER_ATTRIBUTE23
,      SO_HEADER_ATTRIBUTE24
,      SO_HEADER_ATTRIBUTE25
,      SO_HEADER_ATTRIBUTE26
,      SO_HEADER_ATTRIBUTE27
,      SO_HEADER_ATTRIBUTE28
,      SO_HEADER_ATTRIBUTE29
,      SO_HEADER_ATTRIBUTE30
,      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
,      ORDER_STATUS_CODE
FROM GML.GML_GASNO_ORDERS;

Dependencies

[top of page]

GML.GML_GASNO_ORDERS does not reference any database object

GML.GML_GASNO_ORDERS is referenced by following:

SchemaGML
ViewGML_GASNO_ORDERS#