eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GML_GASNO_ORDERS_V

Source

View Text - Preformatted


SELECT oh.order_id ORDER_ID, oh.order_status ORDER_STATUS, os.order_status_code ORDER_STATUS_CODE, oh.custpo_no CUSTPO_NO, oh.order_no ORDER_NO, oh.orgn_code SO_ORGN_CODE, oh.order_comment ORDER_COMMENT, oh.order_date SO_DATE, oh.attribute_category SO_HEADER_CATEGORY, oh.attribute1 SO_HEADER_ATTRIBUTE1, oh.attribute2 SO_HEADER_ATTRIBUTE2, oh.attribute3 SO_HEADER_ATTRIBUTE3, oh.attribute4 SO_HEADER_ATTRIBUTE4, oh.attribute5 SO_HEADER_ATTRIBUTE5, oh.attribute6 SO_HEADER_ATTRIBUTE6, oh.attribute7 SO_HEADER_ATTRIBUTE7, oh.attribute8 SO_HEADER_ATTRIBUTE8, oh.attribute9 SO_HEADER_ATTRIBUTE9, oh.attribute10 SO_HEADER_ATTRIBUTE10, oh.attribute11 SO_HEADER_ATTRIBUTE11, oh.attribute12 SO_HEADER_ATTRIBUTE12, oh.attribute13 SO_HEADER_ATTRIBUTE13, oh.attribute14 SO_HEADER_ATTRIBUTE14, oh.attribute15 SO_HEADER_ATTRIBUTE15, oh.attribute16 SO_HEADER_ATTRIBUTE16, oh.attribute17 SO_HEADER_ATTRIBUTE17, oh.attribute18 SO_HEADER_ATTRIBUTE18, oh.attribute19 SO_HEADER_ATTRIBUTE19, oh.attribute20 SO_HEADER_ATTRIBUTE20, oh.attribute21 SO_HEADER_ATTRIBUTE21, oh.attribute22 SO_HEADER_ATTRIBUTE22, oh.attribute23 SO_HEADER_ATTRIBUTE23, oh.attribute24 SO_HEADER_ATTRIBUTE24, oh.attribute25 SO_HEADER_ATTRIBUTE25, oh.attribute26 SO_HEADER_ATTRIBUTE26, oh.attribute27 SO_HEADER_ATTRIBUTE27, oh.attribute28 SO_HEADER_ATTRIBUTE28, oh.attribute29 SO_HEADER_ATTRIBUTE29, oh.attribute30 SO_HEADER_ATTRIBUTE30 FROM op_ordr_hdr oh, op_ordr_dtl od, op_bill_lad bl, op_cust_mst cm, gml_ec_contact_v ecc, op_ordr_sts os WHERE oh.delete_mark = 0 AND oh.order_status != -1 AND oh.order_id = od.order_id AND oh.order_status = os.order_status AND od.bol_id = bl.bol_id AND od.line_id in /*Just get first line id of order withen shipment*/ ( select min(sqod.line_id) from op_ordr_dtl sqod, op_ordr_hdr sqoh, op_bill_lad sqbl where sqod.bol_id = sqbl.bol_id AND sqoh.order_id = sqod.order_id AND sqod.line_status = 20 group by sqbl.bol_id, sqod.order_id ) AND cm.cust_id = oh.shipcust_id AND ecc.site_use_id = cm.of_ship_to_site_use_id (+) AND ecc.address_id = cm.of_ship_to_address_id (+) AND ecc.customer_id = cm.of_cust_id (+)

View Text - HTML Formatted

SELECT OH.ORDER_ID ORDER_ID
, OH.ORDER_STATUS ORDER_STATUS
, OS.ORDER_STATUS_CODE ORDER_STATUS_CODE
, OH.CUSTPO_NO CUSTPO_NO
, OH.ORDER_NO ORDER_NO
, OH.ORGN_CODE SO_ORGN_CODE
, OH.ORDER_COMMENT ORDER_COMMENT
, OH.ORDER_DATE SO_DATE
, OH.ATTRIBUTE_CATEGORY SO_HEADER_CATEGORY
, OH.ATTRIBUTE1 SO_HEADER_ATTRIBUTE1
, OH.ATTRIBUTE2 SO_HEADER_ATTRIBUTE2
, OH.ATTRIBUTE3 SO_HEADER_ATTRIBUTE3
, OH.ATTRIBUTE4 SO_HEADER_ATTRIBUTE4
, OH.ATTRIBUTE5 SO_HEADER_ATTRIBUTE5
, OH.ATTRIBUTE6 SO_HEADER_ATTRIBUTE6
, OH.ATTRIBUTE7 SO_HEADER_ATTRIBUTE7
, OH.ATTRIBUTE8 SO_HEADER_ATTRIBUTE8
, OH.ATTRIBUTE9 SO_HEADER_ATTRIBUTE9
, OH.ATTRIBUTE10 SO_HEADER_ATTRIBUTE10
, OH.ATTRIBUTE11 SO_HEADER_ATTRIBUTE11
, OH.ATTRIBUTE12 SO_HEADER_ATTRIBUTE12
, OH.ATTRIBUTE13 SO_HEADER_ATTRIBUTE13
, OH.ATTRIBUTE14 SO_HEADER_ATTRIBUTE14
, OH.ATTRIBUTE15 SO_HEADER_ATTRIBUTE15
, OH.ATTRIBUTE16 SO_HEADER_ATTRIBUTE16
, OH.ATTRIBUTE17 SO_HEADER_ATTRIBUTE17
, OH.ATTRIBUTE18 SO_HEADER_ATTRIBUTE18
, OH.ATTRIBUTE19 SO_HEADER_ATTRIBUTE19
, OH.ATTRIBUTE20 SO_HEADER_ATTRIBUTE20
, OH.ATTRIBUTE21 SO_HEADER_ATTRIBUTE21
, OH.ATTRIBUTE22 SO_HEADER_ATTRIBUTE22
, OH.ATTRIBUTE23 SO_HEADER_ATTRIBUTE23
, OH.ATTRIBUTE24 SO_HEADER_ATTRIBUTE24
, OH.ATTRIBUTE25 SO_HEADER_ATTRIBUTE25
, OH.ATTRIBUTE26 SO_HEADER_ATTRIBUTE26
, OH.ATTRIBUTE27 SO_HEADER_ATTRIBUTE27
, OH.ATTRIBUTE28 SO_HEADER_ATTRIBUTE28
, OH.ATTRIBUTE29 SO_HEADER_ATTRIBUTE29
, OH.ATTRIBUTE30 SO_HEADER_ATTRIBUTE30
FROM OP_ORDR_HDR OH
, OP_ORDR_DTL OD
, OP_BILL_LAD BL
, OP_CUST_MST CM
, GML_EC_CONTACT_V ECC
, OP_ORDR_STS OS
WHERE OH.DELETE_MARK = 0
AND OH.ORDER_STATUS != -1
AND OH.ORDER_ID = OD.ORDER_ID
AND OH.ORDER_STATUS = OS.ORDER_STATUS
AND OD.BOL_ID = BL.BOL_ID
AND OD.LINE_ID IN /*JUST GET FIRST LINE ID OF ORDER WITHEN SHIPMENT*/ ( SELECT MIN(SQOD.LINE_ID)
FROM OP_ORDR_DTL SQOD
, OP_ORDR_HDR SQOH
, OP_BILL_LAD SQBL
WHERE SQOD.BOL_ID = SQBL.BOL_ID
AND SQOH.ORDER_ID = SQOD.ORDER_ID
AND SQOD.LINE_STATUS = 20 GROUP BY SQBL.BOL_ID
, SQOD.ORDER_ID )
AND CM.CUST_ID = OH.SHIPCUST_ID
AND ECC.SITE_USE_ID = CM.OF_SHIP_TO_SITE_USE_ID (+)
AND ECC.ADDRESS_ID = CM.OF_SHIP_TO_ADDRESS_ID (+)
AND ECC.CUSTOMER_ID = CM.OF_CUST_ID (+)