VIEW: APPS.RRS_IMPORT_BATCHES_V

Source

View Text - Preformatted

SELECT BATCH_ID FROM ( SELECT DISTINCT BATCH_ID FROM RRS_SITES_INTERFACE WHERE PROCESS_STATUS = '1' UNION SELECT DISTINCT BATCH_ID FROM RRS_SITE_UA_INTF WHERE PROCESS_STATUS = '1' UNION SELECT DISTINCT BATCH_ID FROM RRS_LOCATION_UA_INTF WHERE PROCESS_STATUS = '1' UNION SELECT DISTINCT BATCH_ID FROM RRS_TRADEAREA_UA_INTF WHERE PROCESS_STATUS = '1' )

View Text - HTML Formatted

SELECT BATCH_ID
FROM ( SELECT DISTINCT BATCH_ID
FROM RRS_SITES_INTERFACE
WHERE PROCESS_STATUS = '1' UNION SELECT DISTINCT BATCH_ID
FROM RRS_SITE_UA_INTF
WHERE PROCESS_STATUS = '1' UNION SELECT DISTINCT BATCH_ID
FROM RRS_LOCATION_UA_INTF
WHERE PROCESS_STATUS = '1' UNION SELECT DISTINCT BATCH_ID
FROM RRS_TRADEAREA_UA_INTF
WHERE PROCESS_STATUS = '1' )