View: GMI_AAC_ORDER_NUM_V

Product:	GMI - Process Manufacturing Inventory
Description:	View Of Orders that have been BOOKED and PICK RELEASED which have open Move Order Lines.
Implementation/DBA Data:	APPS.GMI_AAC_ORDER_NUM_V

View Text

SELECT DISTINCT OH.ORDER_NUMBER
, W.WHSE_CODE
FROM ( SELECT SOURCE_HEADER_ID
, SOURCE_LINE_ID
FROM WSH_DELIVERY_DETAILS WDD
, IC_TXN_REQUEST_LINES IC
WHERE MOVE_ORDER_LINE_ID = LINE_ID
AND RELEASED_STATUS = 'S' ) SHP
, OE_ORDER_HEADERS_ALL OH
, OE_ORDER_LINES_ALL OL
, IC_WHSE_MST W
WHERE OH.HEADER_ID = OL.HEADER_ID
AND OL.FLOW_STATUS_CODE = 'AWAITING_SHIPPING'
AND OL.LINE_ID = SHP.SOURCE_LINE_ID
AND OL.HEADER_ID = SHP.SOURCE_HEADER_ID
AND W.MTL_ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID

Columns