Query Project Lookups.sql

SELECT
	ppav.PROJECT_ID
  , ppav.NAME
  , ppav.enabled_flag
  , ppav.SEGMENT1
  , ppav.PROJECT_TYPE_ID
  , ppav.PROJECT_STATUS_CODE
  , ppav.START_DATE
  , ppav.COMPLETION_DATE
  , ptv.task_id
  , ptv.task_name
  , ptv.TASK_NUMBER
FROM
	fusion.PJF_PROJECTS_ALL_VL ppav
  , fusion.PJF_TASKS_V         ptv
WHERE
	ppav.PROJECT_ID =ptv.PROJECT_ID
ORDER BY
	ppav.NAME
  , ptv.task_id