[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:	GML.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

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

ECE_TP_DETAILS

ECE_TP_HEADERS

FND_PROFILE - show dependent code

GML_EC_CONTACT_V

IC_WHSE_MST

OP_CUST_MST

OP_FOBC_MST

OP_FRGT_MTH

OP_ORDR_HDR

OP_ORDR_STS

OP_PORT_MST

OP_SHIP_MST

OP_SHIP_MTH

SY_ADDR_MST

APPS.GML_GPOAO_ORDERS_V is not referenced by any database object