VIEW: APPS.GML_GPOAO_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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