VIEW: APPS.ZPB_PROCESS_DETAILS_V

Source

View Text - Preformatted

SELECT zac.analysis_cycle_id, zac.name cycle_name, zact.task_name, zact.sequence, ztp.name,ztp.task_id,ztp.value,ztp.param_id FROM zpb_analysis_cycles zac, zpb_analysis_cycle_tasks zact, zpb_task_parameters ztp WHERE zac.status_code != 'MARKED_FOR_DELETION' and zac.analysis_cycle_id = zact.analysis_cycle_id and zact.task_id = ztp.task_id ORDER BY zac.analysis_cycle_id, zact.sequence

View Text - HTML Formatted

SELECT ZAC.ANALYSIS_CYCLE_ID
, ZAC.NAME CYCLE_NAME
, ZACT.TASK_NAME
, ZACT.SEQUENCE
, ZTP.NAME
, ZTP.TASK_ID
, ZTP.VALUE
, ZTP.PARAM_ID
FROM ZPB_ANALYSIS_CYCLES ZAC
, ZPB_ANALYSIS_CYCLE_TASKS ZACT
, ZPB_TASK_PARAMETERS ZTP
WHERE ZAC.STATUS_CODE != 'MARKED_FOR_DELETION'
AND ZAC.ANALYSIS_CYCLE_ID = ZACT.ANALYSIS_CYCLE_ID
AND ZACT.TASK_ID = ZTP.TASK_ID ORDER BY ZAC.ANALYSIS_CYCLE_ID
, ZACT.SEQUENCE