VIEW: APPS.HR_DM_PHASE_ITEMS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)