Skip to content

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

VIEW: GML.GML_GPOAO_ORDERS#

Object Details
Object Name: GML_GPOAO_ORDERS#
Object Type: VIEW
Owner: GML
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MAP_ID NUMBER

COMMUNICATION_METHOD VARCHAR2 (2) Yes
TEST_INDICATOR VARCHAR2 (1)
DOCUMENT_ID VARCHAR2 (6)
TP_HEADER_ID NUMBER

TP_DETAIL_ID NUMBER

RUN_ID NUMBER

DOCUMENT_PURPOSE_CODE VARCHAR2 (2)
DOCUMENT_CODE VARCHAR2 (32)
TP_CODE VARCHAR2 (35)
TP_LOCATION_CODE_EXT VARCHAR2 (35)
TP_DESCRIPTION VARCHAR2 (240)
TP_REFERENCE1 VARCHAR2 (240)
TP_REFERENCE2 VARCHAR2 (240)
TRANSACTION_DATE DATE

TP_HEADER_CATEGORY VARCHAR2 (150)
TP_HEADER_ATTRIBUTE1 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE2 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE3 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE4 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE5 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE6 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE7 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE8 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE9 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE10 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE11 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE12 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE13 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE14 VARCHAR2 (150)
TP_HEADER_ATTRIBUTE15 VARCHAR2 (150)
TP_DETAIL_CATEGORY VARCHAR2 (150)
TP_DETAIL_ATTRIBUTE1 VARCHAR2 (150)
TP_DETAIL_ATTRIBUTE2 VARCHAR2 (150)
TP_DETAIL_ATTRIBUTE3 VARCHAR2 (150)
TP_DETAIL_ATTRIBUTE4 VARCHAR2 (150)
TP_DETAIL_ATTRIBUTE5 VARCHAR2 (150)
ORDER_ID NUMBER

ORDER_NO VARCHAR2 (32)
ORGN_CODE VARCHAR2 (4)
ORDER_COMMENT VARCHAR2 (70)
ORDER_STATUS NUMBER

CUSTPO_NO VARCHAR2 (22)
SO_DATE DATE

FRTBILL_MTHD_INT VARCHAR2 (4)
FRTBILL_MTHD_EXT1 VARCHAR2 (30)
FRTBILL_MTHD_EXT2 VARCHAR2 (30)
FRTBILL_MTHD_EXT3 VARCHAR2 (30)
FRTBILL_MTHD_EXT4 VARCHAR2 (30)
FRTBILL_MTHD_EXT5 VARCHAR2 (30)
FRTBILL_DESC VARCHAR2 (40)
EMBARKATION_PORT_INT VARCHAR2 (8)
EMBARKATION_PORT_EXT1 VARCHAR2 (30)
EMBARKATION_PORT_EXT2 VARCHAR2 (30)
EMBARKATION_PORT_EXT3 VARCHAR2 (30)
EMBARKATION_PORT_EXT4 VARCHAR2 (30)
EMBARKATION_PORT_EXT5 VARCHAR2 (30)
EMBARKATION_PORT_DESC VARCHAR2 (70)
DEBARKATION_PORT_INT VARCHAR2 (8)
DEBARKATION_PORT_EXT1 VARCHAR2 (30)
DEBARKATION_PORT_EXT2 VARCHAR2 (30)
DEBARKATION_PORT_EXT3 VARCHAR2 (30)
DEBARKATION_PORT_EXT4 VARCHAR2 (30)
DEBARKATION_PORT_EXT5 VARCHAR2 (30)
DEBARKATION_PORT_DESC VARCHAR2 (70)
FOB_CODE_INT VARCHAR2 (4)
FOB_CODE_EXT1 VARCHAR2 (30)
FOB_CODE_EXT2 VARCHAR2 (30)
FOB_CODE_EXT3 VARCHAR2 (30)
FOB_CODE_EXT4 VARCHAR2 (30)
FOB_CODE_EXT5 VARCHAR2 (30)
FOB_NAME VARCHAR2 (40)
SHIPPER_CODE_INT VARCHAR2 (4)
SHIPPER_CODE_EXT1 VARCHAR2 (20)
SHIPPER_CODE_EXT2 VARCHAR2 (20)
SHIPPER_CODE_EXT3 VARCHAR2 (20)
SHIPPER_CODE_EXT4 VARCHAR2 (20)
SHIPPER_CODE_EXT5 VARCHAR2 (20)
SHIPPER_NAME VARCHAR2 (40)
SHIP_MTHD_INT VARCHAR2 (4)
SHIP_MTHD_EXT1 VARCHAR2 (20)
SHIP_MTHD_EXT2 VARCHAR2 (20)
SHIP_MTHD_EXT3 VARCHAR2 (20)
SHIP_MTHD_EXT4 VARCHAR2 (20)
SHIP_MTHD_EXT5 VARCHAR2 (20)
METH_DESC1 VARCHAR2 (40)
BILLTO_CUST_ID NUMBER

BILLTO_CODE_INT VARCHAR2 (240)
BILLTO_CODE_EXT1 VARCHAR2 (80)
BILLTO_CODE_EXT2 VARCHAR2 (80)
BILLTO_CODE_EXT3 VARCHAR2 (80)
BILLTO_CODE_EXT4 VARCHAR2 (80)
BILLTO_CODE_EXT5 VARCHAR2 (80)
BILLTO_CUST_NAME VARCHAR2 (80)
BILLTO_ADDR1 VARCHAR2 (70)
BILLTO_ADDR2 VARCHAR2 (70)
BILLTO_ADDR3 VARCHAR2 (70)
BILLTO_ADDR4 VARCHAR2 (70)
BILLTO_POSTAL_CODE VARCHAR2 (60)
BILLTO_COUNTRY_CODE_INT VARCHAR2 (60)
BILLTO_COUNTRY_CODE_EXT1 VARCHAR2 (80)
BILLTO_COUNTRY_CODE_EXT2 VARCHAR2 (80)
BILLTO_COUNTRY_CODE_EXT3 VARCHAR2 (80)
BILLTO_COUNTRY_CODE_EXT4 VARCHAR2 (80)
BILLTO_COUNTRY_CODE_EXT5 VARCHAR2 (80)
BILLTO_STATE_CODE_INT VARCHAR2 (60)
BILLTO_STATE_CODE_EXT1 VARCHAR2 (80)
BILLTO_STATE_CODE_EXT2 VARCHAR2 (80)
BILLTO_STATE_CODE_EXT3 VARCHAR2 (80)
BILLTO_STATE_CODE_EXT4 VARCHAR2 (80)
BILLTO_STATE_CODE_EXT5 VARCHAR2 (80)
BILLTO_PROVINCE_CODE_INT VARCHAR2 (60)
BILLTO_PROVINCE_CODE_EXT1 VARCHAR2 (80)
BILLTO_PROVINCE_CODE_EXT2 VARCHAR2 (80)
BILLTO_PROVINCE_CODE_EXT3 VARCHAR2 (80)
BILLTO_PROVINCE_CODE_EXT4 VARCHAR2 (80)
BILLTO_PROVINCE_CODE_EXT5 VARCHAR2 (80)
BILLTO_COUNTY VARCHAR2 (60)
BILLTO_LAST_NAME VARCHAR2 (50)
BILLTO_FIRST_NAME VARCHAR2 (40)
BILLTO_JOB_TITLE VARCHAR2 (50)
BILLTO_AREA_CODE VARCHAR2 (10)
BILLTO_TELEPHONE VARCHAR2 (60)
SHIPTO_CUST_ID NUMBER

SHIPTO_CODE_INT VARCHAR2 (240)
SHIPTO_CODE_EXT1 VARCHAR2 (80)
SHIPTO_CODE_EXT2 VARCHAR2 (80)
SHIPTO_CODE_EXT3 VARCHAR2 (80)
SHIPTO_CODE_EXT4 VARCHAR2 (80)
SHIPTO_CODE_EXT5 VARCHAR2 (80)
SHIPTO_CUST_NAME VARCHAR2 (80)
SHIPTO_ADDR1 VARCHAR2 (70)
SHIPTO_ADDR2 VARCHAR2 (70)
SHIPTO_ADDR3 VARCHAR2 (70)
SHIPTO_ADDR4 VARCHAR2 (70)
SHIPTO_POSTAL_CODE VARCHAR2 (60)
SHIPTO_COUNTRY_CODE_INT VARCHAR2 (60)
SHIPTO_COUNTRY_CODE_EXT1 VARCHAR2 (80)
SHIPTO_COUNTRY_CODE_EXT2 VARCHAR2 (80)
SHIPTO_COUNTRY_CODE_EXT3 VARCHAR2 (80)
SHIPTO_COUNTRY_CODE_EXT4 VARCHAR2 (80)
SHIPTO_COUNTRY_CODE_EXT5 VARCHAR2 (80)
SHIPTO_STATE_CODE_INT VARCHAR2 (60)
SHIPTO_STATE_CODE_EXT1 VARCHAR2 (80)
SHIPTO_STATE_CODE_EXT2 VARCHAR2 (80)
SHIPTO_STATE_CODE_EXT3 VARCHAR2 (80)
SHIPTO_STATE_CODE_EXT4 VARCHAR2 (80)
SHIPTO_STATE_CODE_EXT5 VARCHAR2 (80)
SHIPTO_PROVINCE_CODE_INT VARCHAR2 (60)
SHIPTO_PROVINCE_CODE_EXT1 VARCHAR2 (80)
SHIPTO_PROVINCE_CODE_EXT2 VARCHAR2 (80)
SHIPTO_PROVINCE_CODE_EXT3 VARCHAR2 (80)
SHIPTO_PROVINCE_CODE_EXT4 VARCHAR2 (80)
SHIPTO_PROVINCE_CODE_EXT5 VARCHAR2 (80)
SHIPTO_COUNTY VARCHAR2 (60)
SHIPTO_LAST_NAME VARCHAR2 (50)
SHIPTO_FIRST_NAME VARCHAR2 (40)
SHIPTO_JOB_TITLE VARCHAR2 (50)
SHIPTO_AREA_CODE VARCHAR2 (10)
SHIPTO_TELEPHONE VARCHAR2 (60)
SHIPADDR_ID NUMBER

SHIPADDR_ADDR1 VARCHAR2 (70)
SHIPADDR_ADDR2 VARCHAR2 (70)
SHIPADDR_ADDR3 VARCHAR2 (70)
SHIPADDR_ADDR4 VARCHAR2 (70)
SHIPADDR_POSTAL_CODE VARCHAR2 (60)
SHIPADDR_COUNTRY_CODE_INT VARCHAR2 (60)
SHIPADDR_COUNTRY_CODE_EXT1 VARCHAR2 (80)
SHIPADDR_COUNTRY_CODE_EXT2 VARCHAR2 (80)
SHIPADDR_COUNTRY_CODE_EXT3 VARCHAR2 (80)
SHIPADDR_COUNTRY_CODE_EXT4 VARCHAR2 (80)
SHIPADDR_COUNTRY_CODE_EXT5 VARCHAR2 (80)
SHIPADDR_STATE_CODE_INT VARCHAR2 (60)
SHIPADDR_STATE_CODE_EXT1 VARCHAR2 (80)
SHIPADDR_STATE_CODE_EXT2 VARCHAR2 (80)
SHIPADDR_STATE_CODE_EXT3 VARCHAR2 (80)
SHIPADDR_STATE_CODE_EXT4 VARCHAR2 (80)
SHIPADDR_STATE_CODE_EXT5 VARCHAR2 (80)
SHIPADDR_PROVINCE_CODE_INT VARCHAR2 (60)
SHIPADDR_PROVINCE_CODE_EXT1 VARCHAR2 (80)
SHIPADDR_PROVINCE_CODE_EXT2 VARCHAR2 (80)
SHIPADDR_PROVINCE_CODE_EXT3 VARCHAR2 (80)
SHIPADDR_PROVINCE_CODE_EXT4 VARCHAR2 (80)
SHIPADDR_PROVINCE_CODE_EXT5 VARCHAR2 (80)
SHIPADDR_COUNTY VARCHAR2 (60)
EDI_TRANS_CNT NUMBER

PRINT_COUNT NUMBER

PRINT_DATE DATE

FROM_WHSE VARCHAR2 (4)
FROM_WHSE_NAME VARCHAR2 (50)
FROM_WHSE_CONTACT VARCHAR2 (50)
FROM_WHSE_PHONE VARCHAR2 (60)
FROM_WHSE_ADDR1 VARCHAR2 (70)
FROM_WHSE_ADDR2 VARCHAR2 (70)
FROM_WHSE_ADDR3 VARCHAR2 (70)
FROM_WHSE_ADDR4 VARCHAR2 (70)
FROM_WHSE_POSTAL_CODE VARCHAR2 (60)
FROM_WHSE_COUNTRY_CODE_INT VARCHAR2 (60)
FROM_WHSE_COUNTRY_CODE_EXT1 VARCHAR2 (80)
FROM_WHSE_COUNTRY_CODE_EXT2 VARCHAR2 (80)
FROM_WHSE_COUNTRY_CODE_EXT3 VARCHAR2 (80)
FROM_WHSE_COUNTRY_CODE_EXT4 VARCHAR2 (80)
FROM_WHSE_COUNTRY_CODE_EXT5 VARCHAR2 (80)
FROM_WHSE_STATE_CODE_INT VARCHAR2 (60)
FROM_WHSE_STATE_CODE_EXT1 VARCHAR2 (80)
FROM_WHSE_STATE_CODE_EXT2 VARCHAR2 (80)
FROM_WHSE_STATE_CODE_EXT3 VARCHAR2 (80)
FROM_WHSE_STATE_CODE_EXT4 VARCHAR2 (80)
FROM_WHSE_STATE_CODE_EXT5 VARCHAR2 (80)
FROM_WHSE_PROVINCE_CODE_INT VARCHAR2 (60)
FROM_WHSE_PROVINCE_CODE_EXT1 VARCHAR2 (80)
FROM_WHSE_PROVINCE_CODE_EXT2 VARCHAR2 (80)
FROM_WHSE_PROVINCE_CODE_EXT3 VARCHAR2 (80)
FROM_WHSE_PROVINCE_CODE_EXT4 VARCHAR2 (80)
FROM_WHSE_PROVINCE_CODE_EXT5 VARCHAR2 (80)
FROM_WHSE_COUNTY VARCHAR2 (60)
SO_HEADER_CATEGORY VARCHAR2 (30)
SO_HEADER_ATTRIBUTE1 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE2 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE3 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE4 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE5 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE6 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE7 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE8 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE9 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE10 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE11 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE12 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE13 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE14 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE15 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE16 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE17 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE18 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE19 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE20 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE21 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE22 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE23 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE24 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE25 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE26 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE27 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE28 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE29 VARCHAR2 (240)
SO_HEADER_ATTRIBUTE30 VARCHAR2 (240)
TRANSACTION_RECORD_ID NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE NUMBER (15)
ORDER_STATUS_CODE VARCHAR2 (16)
Query Text

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


SELECT MAP_ID
,      COMMUNICATION_METHOD
,      TEST_INDICATOR
,      DOCUMENT_ID
,      TP_HEADER_ID
,      TP_DETAIL_ID
,      RUN_ID
,      DOCUMENT_PURPOSE_CODE
,      DOCUMENT_CODE
,      TP_CODE
,      TP_LOCATION_CODE_EXT
,      TP_DESCRIPTION
,      TP_REFERENCE1
,      TP_REFERENCE2
,      TRANSACTION_DATE
,      TP_HEADER_CATEGORY
,      TP_HEADER_ATTRIBUTE1
,      TP_HEADER_ATTRIBUTE2
,      TP_HEADER_ATTRIBUTE3
,      TP_HEADER_ATTRIBUTE4
,      TP_HEADER_ATTRIBUTE5
,      TP_HEADER_ATTRIBUTE6
,      TP_HEADER_ATTRIBUTE7
,      TP_HEADER_ATTRIBUTE8
,      TP_HEADER_ATTRIBUTE9
,      TP_HEADER_ATTRIBUTE10
,      TP_HEADER_ATTRIBUTE11
,      TP_HEADER_ATTRIBUTE12
,      TP_HEADER_ATTRIBUTE13
,      TP_HEADER_ATTRIBUTE14
,      TP_HEADER_ATTRIBUTE15
,      TP_DETAIL_CATEGORY
,      TP_DETAIL_ATTRIBUTE1
,      TP_DETAIL_ATTRIBUTE2
,      TP_DETAIL_ATTRIBUTE3
,      TP_DETAIL_ATTRIBUTE4
,      TP_DETAIL_ATTRIBUTE5
,      ORDER_ID
,      ORDER_NO
,      ORGN_CODE
,      ORDER_COMMENT
,      ORDER_STATUS
,      CUSTPO_NO
,      SO_DATE
,      FRTBILL_MTHD_INT
,      FRTBILL_MTHD_EXT1
,      FRTBILL_MTHD_EXT2
,      FRTBILL_MTHD_EXT3
,      FRTBILL_MTHD_EXT4
,      FRTBILL_MTHD_EXT5
,      FRTBILL_DESC
,      EMBARKATION_PORT_INT
,      EMBARKATION_PORT_EXT1
,      EMBARKATION_PORT_EXT2
,      EMBARKATION_PORT_EXT3
,      EMBARKATION_PORT_EXT4
,      EMBARKATION_PORT_EXT5
,      EMBARKATION_PORT_DESC
,      DEBARKATION_PORT_INT
,      DEBARKATION_PORT_EXT1
,      DEBARKATION_PORT_EXT2
,      DEBARKATION_PORT_EXT3
,      DEBARKATION_PORT_EXT4
,      DEBARKATION_PORT_EXT5
,      DEBARKATION_PORT_DESC
,      FOB_CODE_INT
,      FOB_CODE_EXT1
,      FOB_CODE_EXT2
,      FOB_CODE_EXT3
,      FOB_CODE_EXT4
,      FOB_CODE_EXT5
,      FOB_NAME
,      SHIPPER_CODE_INT
,      SHIPPER_CODE_EXT1
,      SHIPPER_CODE_EXT2
,      SHIPPER_CODE_EXT3
,      SHIPPER_CODE_EXT4
,      SHIPPER_CODE_EXT5
,      SHIPPER_NAME
,      SHIP_MTHD_INT
,      SHIP_MTHD_EXT1
,      SHIP_MTHD_EXT2
,      SHIP_MTHD_EXT3
,      SHIP_MTHD_EXT4
,      SHIP_MTHD_EXT5
,      METH_DESC1
,      BILLTO_CUST_ID
,      BILLTO_CODE_INT
,      BILLTO_CODE_EXT1
,      BILLTO_CODE_EXT2
,      BILLTO_CODE_EXT3
,      BILLTO_CODE_EXT4
,      BILLTO_CODE_EXT5
,      BILLTO_CUST_NAME
,      BILLTO_ADDR1
,      BILLTO_ADDR2
,      BILLTO_ADDR3
,      BILLTO_ADDR4
,      BILLTO_POSTAL_CODE
,      BILLTO_COUNTRY_CODE_INT
,      BILLTO_COUNTRY_CODE_EXT1
,      BILLTO_COUNTRY_CODE_EXT2
,      BILLTO_COUNTRY_CODE_EXT3
,      BILLTO_COUNTRY_CODE_EXT4
,      BILLTO_COUNTRY_CODE_EXT5
,      BILLTO_STATE_CODE_INT
,      BILLTO_STATE_CODE_EXT1
,      BILLTO_STATE_CODE_EXT2
,      BILLTO_STATE_CODE_EXT3
,      BILLTO_STATE_CODE_EXT4
,      BILLTO_STATE_CODE_EXT5
,      BILLTO_PROVINCE_CODE_INT
,      BILLTO_PROVINCE_CODE_EXT1
,      BILLTO_PROVINCE_CODE_EXT2
,      BILLTO_PROVINCE_CODE_EXT3
,      BILLTO_PROVINCE_CODE_EXT4
,      BILLTO_PROVINCE_CODE_EXT5
,      BILLTO_COUNTY
,      BILLTO_LAST_NAME
,      BILLTO_FIRST_NAME
,      BILLTO_JOB_TITLE
,      BILLTO_AREA_CODE
,      BILLTO_TELEPHONE
,      SHIPTO_CUST_ID
,      SHIPTO_CODE_INT
,      SHIPTO_CODE_EXT1
,      SHIPTO_CODE_EXT2
,      SHIPTO_CODE_EXT3
,      SHIPTO_CODE_EXT4
,      SHIPTO_CODE_EXT5
,      SHIPTO_CUST_NAME
,      SHIPTO_ADDR1
,      SHIPTO_ADDR2
,      SHIPTO_ADDR3
,      SHIPTO_ADDR4
,      SHIPTO_POSTAL_CODE
,      SHIPTO_COUNTRY_CODE_INT
,      SHIPTO_COUNTRY_CODE_EXT1
,      SHIPTO_COUNTRY_CODE_EXT2
,      SHIPTO_COUNTRY_CODE_EXT3
,      SHIPTO_COUNTRY_CODE_EXT4
,      SHIPTO_COUNTRY_CODE_EXT5
,      SHIPTO_STATE_CODE_INT
,      SHIPTO_STATE_CODE_EXT1
,      SHIPTO_STATE_CODE_EXT2
,      SHIPTO_STATE_CODE_EXT3
,      SHIPTO_STATE_CODE_EXT4
,      SHIPTO_STATE_CODE_EXT5
,      SHIPTO_PROVINCE_CODE_INT
,      SHIPTO_PROVINCE_CODE_EXT1
,      SHIPTO_PROVINCE_CODE_EXT2
,      SHIPTO_PROVINCE_CODE_EXT3
,      SHIPTO_PROVINCE_CODE_EXT4
,      SHIPTO_PROVINCE_CODE_EXT5
,      SHIPTO_COUNTY
,      SHIPTO_LAST_NAME
,      SHIPTO_FIRST_NAME
,      SHIPTO_JOB_TITLE
,      SHIPTO_AREA_CODE
,      SHIPTO_TELEPHONE
,      SHIPADDR_ID
,      SHIPADDR_ADDR1
,      SHIPADDR_ADDR2
,      SHIPADDR_ADDR3
,      SHIPADDR_ADDR4
,      SHIPADDR_POSTAL_CODE
,      SHIPADDR_COUNTRY_CODE_INT
,      SHIPADDR_COUNTRY_CODE_EXT1
,      SHIPADDR_COUNTRY_CODE_EXT2
,      SHIPADDR_COUNTRY_CODE_EXT3
,      SHIPADDR_COUNTRY_CODE_EXT4
,      SHIPADDR_COUNTRY_CODE_EXT5
,      SHIPADDR_STATE_CODE_INT
,      SHIPADDR_STATE_CODE_EXT1
,      SHIPADDR_STATE_CODE_EXT2
,      SHIPADDR_STATE_CODE_EXT3
,      SHIPADDR_STATE_CODE_EXT4
,      SHIPADDR_STATE_CODE_EXT5
,      SHIPADDR_PROVINCE_CODE_INT
,      SHIPADDR_PROVINCE_CODE_EXT1
,      SHIPADDR_PROVINCE_CODE_EXT2
,      SHIPADDR_PROVINCE_CODE_EXT3
,      SHIPADDR_PROVINCE_CODE_EXT4
,      SHIPADDR_PROVINCE_CODE_EXT5
,      SHIPADDR_COUNTY
,      EDI_TRANS_CNT
,      PRINT_COUNT
,      PRINT_DATE
,      FROM_WHSE
,      FROM_WHSE_NAME
,      FROM_WHSE_CONTACT
,      FROM_WHSE_PHONE
,      FROM_WHSE_ADDR1
,      FROM_WHSE_ADDR2
,      FROM_WHSE_ADDR3
,      FROM_WHSE_ADDR4
,      FROM_WHSE_POSTAL_CODE
,      FROM_WHSE_COUNTRY_CODE_INT
,      FROM_WHSE_COUNTRY_CODE_EXT1
,      FROM_WHSE_COUNTRY_CODE_EXT2
,      FROM_WHSE_COUNTRY_CODE_EXT3
,      FROM_WHSE_COUNTRY_CODE_EXT4
,      FROM_WHSE_COUNTRY_CODE_EXT5
,      FROM_WHSE_STATE_CODE_INT
,      FROM_WHSE_STATE_CODE_EXT1
,      FROM_WHSE_STATE_CODE_EXT2
,      FROM_WHSE_STATE_CODE_EXT3
,      FROM_WHSE_STATE_CODE_EXT4
,      FROM_WHSE_STATE_CODE_EXT5
,      FROM_WHSE_PROVINCE_CODE_INT
,      FROM_WHSE_PROVINCE_CODE_EXT1
,      FROM_WHSE_PROVINCE_CODE_EXT2
,      FROM_WHSE_PROVINCE_CODE_EXT3
,      FROM_WHSE_PROVINCE_CODE_EXT4
,      FROM_WHSE_PROVINCE_CODE_EXT5
,      FROM_WHSE_COUNTY
,      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_GPOAO_ORDERS#;

Dependencies

[top of page]

GML.GML_GPOAO_ORDERS# references the following:

SchemaGML
TableGML_GPOAO_ORDERS
GML.GML_GPOAO_ORDERS# is referenced by following:

SchemaAPPS
SynonymGML_GPOAO_ORDERS