VIEW: APPS.HXC_RETVL_DEPST_PROCESSES_V

Source

View Text - Preformatted

SELECT hdp.rowid row_id, 1, hdp.deposit_process_id, hdp.name, hdp.time_source_id, hts.name, hdp.mapping_id, hm.name, hdp.object_version_number, hdp.created_by, hdp.creation_date, hdp.last_updated_by, hdp.last_update_date, hdp.last_update_login FROM hxc_mappings hm, hxc_time_sources hts, hxc_deposit_processes hdp WHERE hdp.time_source_id = hts.time_source_id(+) AND hdp.mapping_id = hm.mapping_id(+) UNION SELECT hrt.rowid row_id, 2, hrt.retrieval_process_id, hrt.name, hrt.time_recipient_id, htr.name, hrt.mapping_id, hm.name, hrt.object_version_number, hrt.created_by, hrt.creation_date, hrt.last_updated_by, hrt.last_update_date, hrt.last_update_login FROM hxc_mappings hm, hxc_time_recipients htr, hxc_retrieval_processes hrt WHERE hrt.time_recipient_id = htr.time_recipient_id(+) AND hrt.mapping_id = hm.mapping_id(+)

View Text - HTML Formatted

SELECT HDP.ROWID ROW_ID
, 1
, HDP.DEPOSIT_PROCESS_ID
, HDP.NAME
, HDP.TIME_SOURCE_ID
, HTS.NAME
, HDP.MAPPING_ID
, HM.NAME
, HDP.OBJECT_VERSION_NUMBER
, HDP.CREATED_BY
, HDP.CREATION_DATE
, HDP.LAST_UPDATED_BY
, HDP.LAST_UPDATE_DATE
, HDP.LAST_UPDATE_LOGIN
FROM HXC_MAPPINGS HM
, HXC_TIME_SOURCES HTS
, HXC_DEPOSIT_PROCESSES HDP
WHERE HDP.TIME_SOURCE_ID = HTS.TIME_SOURCE_ID(+)
AND HDP.MAPPING_ID = HM.MAPPING_ID(+) UNION SELECT HRT.ROWID ROW_ID
, 2
, HRT.RETRIEVAL_PROCESS_ID
, HRT.NAME
, HRT.TIME_RECIPIENT_ID
, HTR.NAME
, HRT.MAPPING_ID
, HM.NAME
, HRT.OBJECT_VERSION_NUMBER
, HRT.CREATED_BY
, HRT.CREATION_DATE
, HRT.LAST_UPDATED_BY
, HRT.LAST_UPDATE_DATE
, HRT.LAST_UPDATE_LOGIN
FROM HXC_MAPPINGS HM
, HXC_TIME_RECIPIENTS HTR
, HXC_RETRIEVAL_PROCESSES HRT
WHERE HRT.TIME_RECIPIENT_ID = HTR.TIME_RECIPIENT_ID(+)
AND HRT.MAPPING_ID = HM.MAPPING_ID(+)