VIEW: APPS.RLM_SCHEDULE_DATES_V

Source

View Text - Preformatted

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, a.ship_to_customer_id, a.ORG_ID from rlm_schedule_lines_all a ,rlm_schedule_interface_hdr_v b WHERE a.header_id = b.header_id and b.origin_table ='SCHEDULE' and a.ORG_ID = b.ORG_ID 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, a.ship_to_customer_id, a.ORG_ID from rlm_interface_lines_all a,rlm_schedule_interface_hdr_v b where a.header_id = b.header_id and b.origin_table ='INTERFACE' and a.process_status <> 5 and a.ORG_ID = b.ORG_ID 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, a.ship_to_customer_id, a.ORG_ID from rlm_schedule_lines_all 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 and a.ORG_ID = b.ORG_ID order by 3,4,5,6,7

View Text - HTML Formatted

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
, A.SHIP_TO_CUSTOMER_ID
, A.ORG_ID
FROM RLM_SCHEDULE_LINES_ALL A
, RLM_SCHEDULE_INTERFACE_HDR_V B
WHERE A.HEADER_ID = B.HEADER_ID
AND B.ORIGIN_TABLE ='SCHEDULE'
AND A.ORG_ID = B.ORG_ID 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
, A.SHIP_TO_CUSTOMER_ID
, A.ORG_ID
FROM RLM_INTERFACE_LINES_ALL A
, RLM_SCHEDULE_INTERFACE_HDR_V B
WHERE A.HEADER_ID = B.HEADER_ID
AND B.ORIGIN_TABLE ='INTERFACE'
AND A.PROCESS_STATUS <> 5
AND A.ORG_ID = B.ORG_ID 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
, A.SHIP_TO_CUSTOMER_ID
, A.ORG_ID
FROM RLM_SCHEDULE_LINES_ALL 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
AND A.ORG_ID = B.ORG_ID ORDER BY 3
, 4
, 5
, 6
, 7