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


VIEW: APPS.GML_GPOAO_ORDERS_V

Object Details
Object Name: GML_GPOAO_ORDERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGML.GML_GPOAO_ORDERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A public view which may be useful for custom reporting or other data
requirements.


Contains sales order header data to support the OPM Outbound Purchase Order Acknowledgement (855/ORDRSP) EDI transaction.
This view is used to populate the GML_GPOAO_ORDERS table by primarily viewing data stored in the OP_ORDR_HDR table in OPM Order Fulfillment.


[View Source]

Columns
Name Datatype Length Mandatory Comments
COMMUNICATION_METHOD CHAR (2)
TEST_INDICATOR VARCHAR2 (1) Yes
DOCUMENT_ID VARCHAR2 (6) Yes
TP_HEADER_ID NUMBER
Yes
TP_DETAIL_ID NUMBER
Yes
DOCUMENT_PURPOSE_CODE CHAR (2)
DOCUMENT_CODE VARCHAR2 (32) Yes
TP_CODE VARCHAR2 (35) Yes
TP_LOCATION_CODE_EXT VARCHAR2 (0)
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 (10) Yes
ORDER_NO VARCHAR2 (32) Yes
ORGN_CODE VARCHAR2 (4) Yes
ORDER_COMMENT VARCHAR2 (70)
ORDER_STATUS NUMBER (5) Yes
ORDER_STATUS_CODE VARCHAR2 (16) Yes
CUSTPO_NO VARCHAR2 (40)
SO_DATE DATE
Yes
FRTBILL_MTHD_INT VARCHAR2 (4)
FRTBILL_DESC VARCHAR2 (40)
EMBARKATION_PORT_INT VARCHAR2 (8)
EMBARKATION_PORT_DESC VARCHAR2 (70)
DEBARKATION_PORT_INT VARCHAR2 (8)
DEBARKATION_PORT_DESC VARCHAR2 (70)
FOB_CODE_INT VARCHAR2 (4)
FOB_NAME VARCHAR2 (40)
SHIPPER_CODE_INT VARCHAR2 (4)
SHIPPER_NAME VARCHAR2 (40)
SHIP_MTHD_INT VARCHAR2 (4)
METH_DESC1 VARCHAR2 (40)
BILLTO_CUST_ID VARCHAR2 (0)
BILLTO_CODE_INT VARCHAR2 (0)
BILLTO_CODE_EXT1 VARCHAR2 (0)
BILLTO_CODE_EXT2 VARCHAR2 (0)
BILLTO_CODE_EXT3 VARCHAR2 (0)
BILLTO_CUST_NAME VARCHAR2 (0)
BILLTO_ADDR1 VARCHAR2 (0)
BILLTO_ADDR2 VARCHAR2 (0)
BILLTO_ADDR3 VARCHAR2 (0)
BILLTO_ADDR4 VARCHAR2 (0)
BILLTO_POSTAL_CODE VARCHAR2 (0)
BILLTO_COUNTRY_CODE_INT VARCHAR2 (0)
BILLTO_STATE_CODE_INT VARCHAR2 (0)
BILLTO_PROVINCE_CODE_INT VARCHAR2 (0)
BILLTO_COUNTY VARCHAR2 (0)
BILLTO_LAST_NAME VARCHAR2 (0)
BILLTO_FIRST_NAME VARCHAR2 (0)
BILLTO_JOB_TITLE VARCHAR2 (0)
BILLTO_AREA_CODE VARCHAR2 (0)
BILLTO_TELEPHONE VARCHAR2 (0)
SHIPTO_CUST_ID VARCHAR2 (0)
SHIPTO_CODE_INT VARCHAR2 (0)
SHIPTO_CODE_EXT1 VARCHAR2 (0)
SHIPTO_CODE_EXT2 VARCHAR2 (0)
SHIPTO_CODE_EXT3 VARCHAR2 (0)
SHIPTO_CUST_NAME VARCHAR2 (0)
SHIPTO_ADDR1 VARCHAR2 (0)
SHIPTO_ADDR2 VARCHAR2 (0)
SHIPTO_ADDR3 VARCHAR2 (0)
SHIPTO_ADDR4 VARCHAR2 (0)
SHIPTO_POSTAL_CODE VARCHAR2 (0)
SHIPTO_COUNTRY_CODE_INT VARCHAR2 (0)
SHIPTO_STATE_CODE_INT VARCHAR2 (0)
SHIPTO_PROVINCE_CODE_INT VARCHAR2 (0)
SHIPTO_COUNTY VARCHAR2 (0)
SHIPTO_LAST_NAME VARCHAR2 (0)
SHIPTO_FIRST_NAME VARCHAR2 (0)
SHIPTO_JOB_TITLE VARCHAR2 (0)
SHIPTO_AREA_CODE VARCHAR2 (0)
SHIPTO_TELEPHONE VARCHAR2 (0)
SHIPADDR_ID NUMBER (10)
SHIPADDR_ADDR1 VARCHAR2 (70)
SHIPADDR_ADDR2 VARCHAR2 (70)
SHIPADDR_ADDR3 VARCHAR2 (70)
SHIPADDR_ADDR4 VARCHAR2 (70)
SHIPADDR_POSTAL_CODE VARCHAR2 (16)
SHIPADDR_COUNTRY_CODE_INT VARCHAR2 (4)
SHIPADDR_STATE_CODE_INT VARCHAR2 (4)
SHIPADDR_PROVINCE_CODE_INT VARCHAR2 (70)
SHIPADDR_COUNTY VARCHAR2 (70)
EDI_TRANS_CNT NUMBER (5)
PRINT_COUNT NUMBER (5) Yes
PRINT_DATE DATE

CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
FROM_WHSE VARCHAR2 (4)
FROM_WHSE_NAME VARCHAR2 (40)
FROM_WHSE_CONTACT VARCHAR2 (40)
FROM_WHSE_PHONE VARCHAR2 (20)
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 (16)
FROM_WHSE_COUNTRY_CODE_INT VARCHAR2 (4)
FROM_WHSE_STATE_CODE_INT VARCHAR2 (4)
FROM_WHSE_PROVINCE_CODE_INT VARCHAR2 (70)
FROM_WHSE_COUNTY VARCHAR2 (70)
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)
Query Text

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


SELECT COMMUNICATION_METHOD
,      TEST_INDICATOR
,      DOCUMENT_ID
,      TP_HEADER_ID
,      TP_DETAIL_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
,      ORDER_STATUS_CODE
,      CUSTPO_NO
,      SO_DATE
,      FRTBILL_MTHD_INT
,      FRTBILL_DESC
,      EMBARKATION_PORT_INT
,      EMBARKATION_PORT_DESC
,      DEBARKATION_PORT_INT
,      DEBARKATION_PORT_DESC
,      FOB_CODE_INT
,      FOB_NAME
,      SHIPPER_CODE_INT
,      SHIPPER_NAME
,      SHIP_MTHD_INT
,      METH_DESC1
,      BILLTO_CUST_ID
,      BILLTO_CODE_INT
,      BILLTO_CODE_EXT1
,      BILLTO_CODE_EXT2
,      BILLTO_CODE_EXT3
,      BILLTO_CUST_NAME
,      BILLTO_ADDR1
,      BILLTO_ADDR2
,      BILLTO_ADDR3
,      BILLTO_ADDR4
,      BILLTO_POSTAL_CODE
,      BILLTO_COUNTRY_CODE_INT
,      BILLTO_STATE_CODE_INT
,      BILLTO_PROVINCE_CODE_INT
,      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_CUST_NAME
,      SHIPTO_ADDR1
,      SHIPTO_ADDR2
,      SHIPTO_ADDR3
,      SHIPTO_ADDR4
,      SHIPTO_POSTAL_CODE
,      SHIPTO_COUNTRY_CODE_INT
,      SHIPTO_STATE_CODE_INT
,      SHIPTO_PROVINCE_CODE_INT
,      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_STATE_CODE_INT
,      SHIPADDR_PROVINCE_CODE_INT
,      SHIPADDR_COUNTY
,      EDI_TRANS_CNT
,      PRINT_COUNT
,      PRINT_DATE
,      CREATION_DATE
,      LAST_UPDATE_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_STATE_CODE_INT
,      FROM_WHSE_PROVINCE_CODE_INT
,      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
FROM APPS.GML_GPOAO_ORDERS_V;

Dependencies

[top of page]

APPS.GML_GPOAO_ORDERS_V references the following:

SchemaAPPS
SynonymECE_TP_DETAILS
SynonymECE_TP_HEADERS
PL/SQL PackageFND_PROFILE - show dependent code
ViewGML_EC_CONTACT_V
SynonymIC_WHSE_MST
SynonymOP_CUST_MST
SynonymOP_FOBC_MST
SynonymOP_FRGT_MTH
SynonymOP_ORDR_HDR
SynonymOP_ORDR_STS
SynonymOP_PORT_MST
SynonymOP_SHIP_MST
SynonymOP_SHIP_MTH
SynonymSY_ADDR_MST

APPS.GML_GPOAO_ORDERS_V is not referenced by any database object