View: RLM_SCHEDULE_DATES_V

Product:	RLM - Release Management
Description:
Implementation/DBA Data:	APPS.RLM_SCHEDULE_DATES_V

View Text

SELECT DISTINCT A.HEADER_ID
, 'SCHEDULE' ORIGIN_TABLE
, A.CUST_SHIP_FROM_ORG_EXT
, A.SHIP_FROM_ORG_ID
, A.SHIP_TO_ORG_ID
, A.CUST_SHIP_TO_EXT
, A.SHIP_TO_ADDRESS_ID
, START_DATE_TIME
FROM RLM_SCHEDULE_LINES A
, RLM_SCHEDULE_INTERFACE_HDR_V B
WHERE A.HEADER_ID = B.HEADER_ID
AND B.ORIGIN_TABLE ='SCHEDULE' UNION SELECT DISTINCT A.HEADER_ID
, 'INTERFACE' ORIGIN_TABLE
, A.CUST_SHIP_FROM_ORG_EXT
, A.SHIP_FROM_ORG_ID
, A.SHIP_TO_ORG_ID
, A.CUST_SHIP_TO_EXT
, A.SHIP_TO_ADDRESS_ID
, START_DATE_TIME
FROM RLM_INTERFACE_LINES A
, RLM_SCHEDULE_INTERFACE_HDR_V B
WHERE A.HEADER_ID = B.HEADER_ID
AND B.ORIGIN_TABLE ='INTERFACE'
AND A.PROCESS_STATUS <> 5 UNION SELECT DISTINCT B.HEADER_ID
, 'INTERFACE' ORIGIN_TABLE
, A.CUST_SHIP_FROM_ORG_EXT
, A.SHIP_FROM_ORG_ID
, A.SHIP_TO_ORG_ID
, A.CUST_SHIP_TO_EXT
, A.SHIP_TO_ADDRESS_ID
, START_DATE_TIME
FROM RLM_SCHEDULE_LINES A
, RLM_SCHEDULE_INTERFACE_HDR_V B
WHERE A.HEADER_ID = B.SCHEDULE_HEADER_ID
AND B.ORIGIN_TABLE ='INTERFACE'
AND A.PROCESS_STATUS = 5 ORDER BY 3
, 4
, 5
, 6
, 7

Columns