Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_RETVL_DEPST_PROCESSES_V |
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(+)