Product: | PER - Human Resources |
---|---|
Description: | View to support DM UI - hr_dm_phase_items |
Implementation/DBA Data: | APPS.HR_DM_PHASE_ITEMS_V |
SELECT H1.PHASE_ITEM_ID
, H1.PHASE_ID
, H1.LOADER_NAME
, H1.BATCH_ID
, H4.BATCH_NAME
, H1.GROUP_ID
, H2.DESCRIPTION
, H1.TABLE_NAME
, H1.STATUS
, HR_GENERAL.DECODE_LOOKUP('HR_DM_STATUS'
, H1.STATUS) STATUS_MEANING
, H1.START_TIME
, H1.END_TIME
, H1.LAST_UPDATE_DATE
, H1.LAST_UPDATED_BY
, H1.LAST_UPDATE_LOGIN
, H1.CREATED_BY
, H1.CREATION_DATE
, H2.DESCRIPTION TABLE_DESCRIPTION
, H3.LOADER_CONC_PROGRAM
FROM HR_DM_PHASE_ITEMS H1
, HR_DM_GROUPS H2
, HR_DM_TABLES H3
, HR_PUMP_BATCH_HEADERS H4
WHERE H1.GROUP_ID = H2.GROUP_ID (+)
AND H1.BATCH_ID = H4.BATCH_ID (+)
AND H1.LOADER_NAME = H3.LOADER_NAME (+)