Product: | GML - Process Manufacturing Logistics |
---|---|
Description: | Sales Order Header view |
Implementation/DBA Data: | APPS.GML_GASNO_ORDERS_V |
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 (+)