eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WSH_ITM_REFERENCE_LINES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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