VIEW: APPS.WSH_ITM_REFERENCE_NUMBERS_V

Source

View Text - Preformatted

SELECT DISTINCT application_id, original_system_reference reference_id, wrc.order_type, oh.order_number reference_number, oh.flow_status_code status_code from wsh_itm_request_control wrc, oe_order_headers_all oh WHERE wrc.original_system_reference = oh.header_id and wrc.application_id = 660 UNION SELECT WRC.APPLICATION_ID, ne.DELIVERY_ID, DEF.ORGANIZATION_NAME, ne.DELIVERY_ID, ne.status_code status_code FROM WSH_ITM_REQUEST_CONTROL WRC, WSH_NEW_DELIVERIES NE, ORG_ORGANIZATION_DEFINITIONS DEF WHERE WRC.ORIGINAL_SYSTEM_REFERENCE=NE.DELIVERY_ID AND DEF.ORGANIZATION_ID=NE.ORGANIZATION_ID AND WRC.APPLICATION_ID=665 and NE.DELIVERY_TYPE='STANDARD'

View Text - HTML Formatted

SELECT DISTINCT APPLICATION_ID
, ORIGINAL_SYSTEM_REFERENCE REFERENCE_ID
, WRC.ORDER_TYPE
, OH.ORDER_NUMBER REFERENCE_NUMBER
, OH.FLOW_STATUS_CODE STATUS_CODE
FROM WSH_ITM_REQUEST_CONTROL WRC
, OE_ORDER_HEADERS_ALL OH
WHERE WRC.ORIGINAL_SYSTEM_REFERENCE = OH.HEADER_ID
AND WRC.APPLICATION_ID = 660 UNION SELECT WRC.APPLICATION_ID
, NE.DELIVERY_ID
, DEF.ORGANIZATION_NAME
, NE.DELIVERY_ID
, NE.STATUS_CODE STATUS_CODE
FROM WSH_ITM_REQUEST_CONTROL WRC
, WSH_NEW_DELIVERIES NE
, ORG_ORGANIZATION_DEFINITIONS DEF
WHERE WRC.ORIGINAL_SYSTEM_REFERENCE=NE.DELIVERY_ID
AND DEF.ORGANIZATION_ID=NE.ORGANIZATION_ID
AND WRC.APPLICATION_ID=665
AND NE.DELIVERY_TYPE='STANDARD'