[Home] [Help] [Dependency Information]

VIEW: APPS.GML_GPOAO_DETAILS_V

Object Details

Object Name:	GML_GPOAO_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GML.GML_GPOAO_DETAILS_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 detail data to support the OPM Outbound Purchase Order Acknowledgement (855/ORDRSP) EDI transaction.
This view is used to populate the GML_GPOAO_DETAILS table by primarily viewing data stored in the OP_ORDR_DTL table in OPM Order Fulfillment.

[View Source]

Columns

Query Text

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

SELECT ORDER_ID
,      LINE_ID
,      LINE_STATUS
,      LINE_STATUS_CODE
,      SHIP_STATUS
,      SO_LINE_NO
,      TRANS_CNT
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ACTUAL_SHIPDATE
,      REQUESTED_SHIPDATE
,      PROMISED_SHIPDATE
,      SCHED_SHIPDATE
,      ACTUAL_DLVDATE
,      REQUIRED_DLVDATE
,      HOLD_EXPIRATION
,      EXPORT_DATE
,      LINE_COMMENT
,      SO_DETAIL_CATEGORY
,      SO_DETAIL_ATTRIBUTE1
,      SO_DETAIL_ATTRIBUTE2
,      SO_DETAIL_ATTRIBUTE3
,      SO_DETAIL_ATTRIBUTE4
,      SO_DETAIL_ATTRIBUTE5
,      SO_DETAIL_ATTRIBUTE6
,      SO_DETAIL_ATTRIBUTE7
,      SO_DETAIL_ATTRIBUTE8
,      SO_DETAIL_ATTRIBUTE9
,      SO_DETAIL_ATTRIBUTE10
,      SO_DETAIL_ATTRIBUTE11
,      SO_DETAIL_ATTRIBUTE12
,      SO_DETAIL_ATTRIBUTE13
,      SO_DETAIL_ATTRIBUTE14
,      SO_DETAIL_ATTRIBUTE15
,      SO_DETAIL_ATTRIBUTE16
,      SO_DETAIL_ATTRIBUTE17
,      SO_DETAIL_ATTRIBUTE18
,      SO_DETAIL_ATTRIBUTE19
,      SO_DETAIL_ATTRIBUTE20
,      SO_DETAIL_ATTRIBUTE21
,      SO_DETAIL_ATTRIBUTE22
,      SO_DETAIL_ATTRIBUTE23
,      SO_DETAIL_ATTRIBUTE24
,      SO_DETAIL_ATTRIBUTE25
,      SO_DETAIL_ATTRIBUTE26
,      SO_DETAIL_ATTRIBUTE27
,      SO_DETAIL_ATTRIBUTE28
,      SO_DETAIL_ATTRIBUTE29
,      SO_DETAIL_ATTRIBUTE30
,      SHIP_METHOD_INT
,      BASE_CURRENCY_INT
,      BILLING_CURRENCY_INT
,      HOLDREAS_CODE_INT
,      EXCHANGE_RATE
,      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
,      NET_WT
,      TARE_WT
,      PALLET_WT
,      FRTBILL_WT
,      SHIPWT_UM_INT
,      SHIP_VOLUME
,      SHIPVOLUME_UM_INT
,      ORDR_QTY1
,      SHIP_QTY1
,      ORDER_UM1_INT
,      ORDR_QTY2
,      SHIP_QTY2
,      ORDER_UM2_INT
,      ITEM_NO
,      ITEM_DESC1
,      GENERIC_ITEM
,      LINE_DESC
,      TO_WHSE
,      TO_WHSE_NAME
,      PRICEREAS_CODE_INT
,      PRICEREAS_DESC
,      BASE_PRICE
,      NET_PRICE
,      EXTENDED_PRICE
,      LIST_PRICE
,      SYSTEM_PRICE
,      NET_TAX
,      BILL_QTY
,      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
FROM APPS.GML_GPOAO_DETAILS_V;

Dependencies

[top of page]

APPS

ECE_TP_DETAILS

ECE_TP_HEADERS

FND_PROFILE - show dependent code

GML_EC_CONTACT_V

IC_ITEM_MST

IC_WHSE_MST

OP_CUST_MST

OP_GNRC_ITM

OP_ORDR_DTL

OP_ORDR_HDR

OP_ORDR_STS

OP_PRCE_CDS

SY_ADDR_MST

APPS.GML_GPOAO_DETAILS_V is not referenced by any database object