[Home] [Help]
View: OP_ORDR_HDR_VW1
Product: | GML - Process Manufacturing Logistics |
Description: | View containing order header information used for lookups. |
Implementation/DBA Data: |
APPS.OP_ORDR_HDR_VW1
|
View Text
SELECT DISTINCT HDR.ORDER_ID
, HDR.ORGN_CODE
, HDR.ORDER_NO
, HDR.SHIPCUST_ID
, CUS.CUST_NO
, HDR.DELETE_MARK
FROM OP_ORDR_HDR HDR
, OP_ORDR_DTL DTL
, OP_HOLD_CDS HLD
, OP_CUST_MST CUS
WHERE HDR.ORDER_ID = DTL.ORDER_ID
AND HDR.HOLDREAS_CODE = HLD.HOLDREAS_CODE
AND HDR.SHIPCUST_ID = CUS.CUST_ID /*
AND HDR.ORDER_TYPE = 1 */ /* REMOVED LIMITATION ON ORDER TYPE */
AND DTL.COMPLETED_IND = 0
AND DTL.SHIP_STATUS = 0
AND DTL.BOL_ID = 0
AND HLD.PICKING_IND = 0
AND DTL.DELETE_MARK <> 1
Columns
Name |
ORDER_ID |
ORGN_CODE |
ORDER_NO |
SHIPCUST_ID |
CUST_NO |
DELETE_MARK |