View: WSH_ITM_REFERENCE_LINES_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_ITM_REFERENCE_LINES_V

View Text

SELECT DISTINCT APPLICATION_ID APPLICATION_ID
, WRC.ORIGINAL_SYSTEM_REFERENCE REFERENCE_HEADER_ID
, WRC.ORIGINAL_SYSTEM_LINE_REFERENCE REFERENCE_LINE_ID
, OE_FLEX_UTIL.GET_CONCAT_VALUE(OL.LINE_NUMBER
, OL.SHIPMENT_NUMBER
, OL.OPTION_NUMBER
, OL.COMPONENT_NUMBER
, OL.SERVICE_NUMBER ) REFERENCE_LINE_NUMBER
, OL.FLOW_STATUS_CODE FLOW_STATUS_CODE
FROM OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS_ALL OH
, WSH_ITM_REQUEST_CONTROL WRC
WHERE OH.HEADER_ID = OL.HEADER_ID
AND OH.HEADER_ID = WRC.ORIGINAL_SYSTEM_REFERENCE
AND 660 = WRC.APPLICATION_ID
AND WRC.ORIGINAL_SYSTEM_LINE_REFERENCE = OL.LINE_ID

Columns