VIEW: APPS.GMI_AAC_ORDER_NUM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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