View: GML_GPOAO_DETAILS_V

Product:	GML - Process Manufacturing Logistics
Description:	Sales Order Detail view
Implementation/DBA Data:	APPS.GML_GPOAO_DETAILS_V

View Text

SELECT OH.ORDER_ID ORDER_ID
, OD.LINE_ID LINE_ID
, OD.LINE_STATUS LINE_STATUS
, OS.ORDER_STATUS_CODE LINE_STATUS_CODE
, OD.SHIP_STATUS SHIP_STATUS
, OD.LINE_NO SO_LINE_NO
, OD.TRANS_CNT TRANS_CNT
, OD.CREATION_DATE CREATION_DATE
, OD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OD.ACTUAL_SHIPDATE ACTUAL_SHIPDATE
, OD.REQUESTED_SHIPDATE REQUESTED_SHIPDATE
, OD.PROMISED_SHIPDATE PROMISED_SHIPDATE
, OD.SCHED_SHIPDATE SCHED_SHIPDATE
, OD.ACTUAL_DLVDATE ACTUAL_DLVDATE
, OD.REQUIRED_DLVDATE REQUIRED_DLVDATE
, OD.HOLD_EXPIRATION HOLD_EXPIRATION
, OD.EXPORTED_DATE EXPORT_DATE
, OD.LINE_COMMENT LINE_COMMENT
, OD.ATTRIBUTE_CATEGORY SO_DETAIL_CATEGORY
, OD.ATTRIBUTE1 SO_DETAIL_ATTRIBUTE1
, OD.ATTRIBUTE2 SO_DETAIL_ATTRIBUTE2
, OD.ATTRIBUTE3 SO_DETAIL_ATTRIBUTE3
, OD.ATTRIBUTE4 SO_DETAIL_ATTRIBUTE4
, OD.ATTRIBUTE5 SO_DETAIL_ATTRIBUTE5
, OD.ATTRIBUTE6 SO_DETAIL_ATTRIBUTE6
, OD.ATTRIBUTE7 SO_DETAIL_ATTRIBUTE7
, OD.ATTRIBUTE8 SO_DETAIL_ATTRIBUTE8
, OD.ATTRIBUTE9 SO_DETAIL_ATTRIBUTE9
, OD.ATTRIBUTE10 SO_DETAIL_ATTRIBUTE10
, OD.ATTRIBUTE11 SO_DETAIL_ATTRIBUTE11
, OD.ATTRIBUTE12 SO_DETAIL_ATTRIBUTE12
, OD.ATTRIBUTE13 SO_DETAIL_ATTRIBUTE13
, OD.ATTRIBUTE14 SO_DETAIL_ATTRIBUTE14
, OD.ATTRIBUTE15 SO_DETAIL_ATTRIBUTE15
, OD.ATTRIBUTE16 SO_DETAIL_ATTRIBUTE16
, OD.ATTRIBUTE17 SO_DETAIL_ATTRIBUTE17
, OD.ATTRIBUTE18 SO_DETAIL_ATTRIBUTE18
, OD.ATTRIBUTE19 SO_DETAIL_ATTRIBUTE19
, OD.ATTRIBUTE20 SO_DETAIL_ATTRIBUTE20
, OD.ATTRIBUTE21 SO_DETAIL_ATTRIBUTE21
, OD.ATTRIBUTE22 SO_DETAIL_ATTRIBUTE22
, OD.ATTRIBUTE23 SO_DETAIL_ATTRIBUTE23
, OD.ATTRIBUTE24 SO_DETAIL_ATTRIBUTE24
, OD.ATTRIBUTE25 SO_DETAIL_ATTRIBUTE25
, OD.ATTRIBUTE26 SO_DETAIL_ATTRIBUTE26
, OD.ATTRIBUTE27 SO_DETAIL_ATTRIBUTE27
, OD.ATTRIBUTE28 SO_DETAIL_ATTRIBUTE28
, OD.ATTRIBUTE29 SO_DETAIL_ATTRIBUTE29
, OD.ATTRIBUTE30 SO_DETAIL_ATTRIBUTE30
, OD.SHIP_MTHD SHIP_METHOD_INT
, OD.BASE_CURRENCY BASE_CURRENCY_INT
, OD.BILLING_CURRENCY BILLING_CURRENCY_INT
, OD.HOLDREAS_CODE HOLDREAS_CODE_INT
, OD.EXCHANGE_RATE EXCHANGE_RATE
, ECC.CUSTOMER_ID SHIPTO_CUST_ID
, ECC.ORIG_SYSTEM_REFERENCE SHIPTO_CODE_INT
, ECC.TP_LOCATION_CODE_EXT SHIPTO_CODE_EXT1
, ECC.TP_REFERENCE_EXT1 SHIPTO_CODE_EXT2
, ECC.TP_REFERENCE_EXT2 SHIPTO_CODE_EXT3
, ECC.CUSTOMER_NAME SHIPTO_CUST_NAME
, ECC.ADDRESS1 SHIPTO_ADDR1
, ECC.ADDRESS2 SHIPTO_ADDR2
, ECC.ADDRESS3 SHIPTO_ADDR3
, ECC.ADDRESS4 SHIPTO_ADDR4
, ECC.POSTAL_CODE SHIPTO_POSTAL_CODE
, ECC.COUNTRY SHIPTO_COUNTRY_CODE_INT
, ECC.STATE SHIPTO_STATE_CODE_INT
, ECC.PROVINCE SHIPTO_PROVINCE_CODE_INT
, ECC.COUNTY SHIPTO_COUNTY
, ECC.LAST_NAME SHIPTO_LAST_NAME
, ECC.FIRST_NAME SHIPTO_FIRST_NAME
, ECC.JOB_TITLE SHIPTO_JOB_TITLE
, ECC.AREA_CODE SHIPTO_AREA_CODE
, ECC.PHONE_NUMBER SHIPTO_TELEPHONE
, OD.NET_WT NET_WT
, OD.TARE_WT TARE_WT
, OD.PALLET_WT PALLET_WT
, OD.FRTBILL_WT FRTBILL_WT
, OD.SHIPWT_UM SHIPWT_UM_INT
, OD.SHIP_VOLUME SHIP_VOLUME
, OD.SHIPVOLUME_UM SHIPVOLUME_UM_INT
, OD.ORDER_QTY1 ORDR_QTY1
, OD.SHIP_QTY1 SHIP_QTY1
, OD.ORDER_UM1 ORDER_UM1_INT
, OD.ORDER_QTY2 ORDR_QTY2
, OD.SHIP_QTY2 SHIP_QTY2
, OD.ORDER_UM2 ORDER_UM2_INT
, IM.ITEM_NO ITEM_NO
, IM.ITEM_DESC1 ITEM_DESC1
, GI.GENERIC_ITEM GENERIC_ITEM
, OD.LINE_DESC LINE_DESC
, OD.TO_WHSE TO_WHSE
, WM2.WHSE_NAME TO_WHSE_NAME
, OD.PRICEREAS_CODE PRICEREAS_CODE_INT
, PC.PRICE_REASON PRICEREAS_DESC
, OD.BASE_PRICE BASE_PRICE
, OD.NET_PRICE NET_PRICE
, OD.EXTENDED_PRICE EXTENDED_PRICE
, OD.LIST_PRICE LIST_PRICE
, OD.SYSTEM_PRICE SYSTEM_PRICE
, OD.NET_TAX NET_TAX
, OD.BILL_QTY BILL_QTY
, OD.FROM_WHSE FROM_WHSE
, WM.WHSE_NAME FROM_WHSE_NAME
, WM.WHSE_CONTACT FROM_WHSE_CONTACT
, WM.WHSE_PHONE FROM_WHSE_PHONE
, WAM.ADDR1 FROM_WHSE_ADDR1
, WAM.ADDR2 FROM_WHSE_ADDR2
, WAM.ADDR3 FROM_WHSE_ADDR3
, WAM.ADDR4 FROM_WHSE_ADDR4
, WAM.POSTAL_CODE FROM_WHSE_POSTAL_CODE
, WAM.COUNTRY_CODE FROM_WHSE_COUNTRY_CODE_INT
, WAM.STATE_CODE FROM_WHSE_STATE_CODE_INT
, WAM.PROVINCE FROM_WHSE_PROVINCE_CODE_INT
, WAM.COUNTY FROM_WHSE_COUNTY
FROM OP_ORDR_HDR OH
, OP_ORDR_DTL OD
, ECE_TP_HEADERS ETH
, ECE_TP_DETAILS ETD
, GML_EC_CONTACT_V ECC
, IC_ITEM_MST IM
, OP_PRCE_CDS PC
, OP_GNRC_ITM GI
, IC_WHSE_MST WM
, IC_WHSE_MST WM2
, SY_ADDR_MST WAM
, OP_CUST_MST CM
, OP_ORDR_STS OS
WHERE ETD.DOCUMENT_ID = 'GPOAO'
AND ETD.EDI_FLAG = 'Y'
AND ETH.TP_HEADER_ID = ETD.TP_HEADER_ID
AND ECC.TP_HEADER_ID = ETD.TP_HEADER_ID
AND OH.ORDER_ID = OD.ORDER_ID
AND OD.LINE_STATUS = OS.ORDER_STATUS
AND CM.CUST_ID (+) = OD.SHIPCUST_ID
AND IM.ITEM_ID = OD.ITEM_ID
AND GI.ITEM_ID (+) = OD.ITEM_ID
AND GI.CUST_ID (+) = OD.SHIPCUST_ID
AND PC.PRICEREAS_CODE (+) = OD.PRICEREAS_CODE
AND WM.WHSE_CODE (+) = OD.FROM_WHSE
AND WM2.WHSE_CODE (+) = OD.TO_WHSE
AND WAM.ADDR_ID (+) = WM.ADDR_ID
AND ECC.CUSTOMER_ID (+) = CM.OF_CUST_ID
AND ECC.SITE_USE_ID (+) = CM.OF_SHIP_TO_SITE_USE_ID
AND ECC.ADDRESS_ID (+) = CM.OF_SHIP_TO_ADDRESS_ID

Columns