VIEW: APPS.FII_PROJ_TOP_TASK_FKV

Source

View Text - Preformatted

SELECT task_id, project_id, task_id ||'-' || edw_instance.get_code from pa_tasks WHERE task_id = top_task_id

View Text - HTML Formatted

SELECT TASK_ID
, PROJECT_ID
, TASK_ID ||'-' || EDW_INSTANCE.GET_CODE
FROM PA_TASKS
WHERE TASK_ID = TOP_TASK_ID