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