VIEW: APPS.MTH_SRC_OP_SALES_ORDERS_V

Source

View Text - Preformatted

SELECT HEADER_ID, RESERVATION_ID,SUPPLY_SOURCE_HEADER_ID,SOURCE FROM (SELECT h.header_id, r.reservation_id, r.supply_source_header_id, 1 source FROM oe_order_headers_all h, oe_order_lines_all l, mtl_reservations r WHERE h.open_flag = 'Y' AND h.header_id = l.header_id AND l.line_id = r.DEMAND_SOURCE_LINE_ID AND r.SUPPLY_SOURCE_HEADER_ID IS NOT NULL AND r.DEMAND_SOURCE_TYPE_ID = 2 AND r.SUPPLY_SOURCE_TYPE_ID in (5,13) UNION ALL SELECT h.header_id, r.batch_res_id reservation_id, r.batch_id supply_source_header_id, 2 source FROM oe_order_headers_all h, oe_order_lines_all l, gml_batch_so_reservations r WHERE h.open_flag = 'Y' AND h.header_id = l.header_id AND l.LINE_ID = r.SO_LINE_ID AND r.DELETE_MARK = 0)

View Text - HTML Formatted

SELECT HEADER_ID
, RESERVATION_ID
, SUPPLY_SOURCE_HEADER_ID
, SOURCE
FROM (SELECT H.HEADER_ID
, R.RESERVATION_ID
, R.SUPPLY_SOURCE_HEADER_ID
, 1 SOURCE
FROM OE_ORDER_HEADERS_ALL H
, OE_ORDER_LINES_ALL L
, MTL_RESERVATIONS R
WHERE H.OPEN_FLAG = 'Y'
AND H.HEADER_ID = L.HEADER_ID
AND L.LINE_ID = R.DEMAND_SOURCE_LINE_ID
AND R.SUPPLY_SOURCE_HEADER_ID IS NOT NULL
AND R.DEMAND_SOURCE_TYPE_ID = 2
AND R.SUPPLY_SOURCE_TYPE_ID IN (5
, 13) UNION ALL SELECT H.HEADER_ID
, R.BATCH_RES_ID RESERVATION_ID
, R.BATCH_ID SUPPLY_SOURCE_HEADER_ID
, 2 SOURCE
FROM OE_ORDER_HEADERS_ALL H
, OE_ORDER_LINES_ALL L
, GML_BATCH_SO_RESERVATIONS R
WHERE H.OPEN_FLAG = 'Y'
AND H.HEADER_ID = L.HEADER_ID
AND L.LINE_ID = R.SO_LINE_ID
AND R.DELETE_MARK = 0)