[Home] [Help]
View: PA_PROG_AS_OF_DATES
View Text
SELECT PPE.PROJECT_ID
, PPE.PROJ_ELEMENT_ID
, PA_PROGRESS_UTILS.AS_OF_DATE(PPE.PROJECT_ID
, PPE.PROJ_ELEMENT_ID
, PPP.PROGRESS_CYCLE_ID ) AS_OF_DATE
FROM PA_RESOURCE_TYPES PO
, PA_PROJ_PROGRESS_ATTR PPP
, PA_PROJ_ELEMENTS PPE
WHERE PPE.PROJECT_ID = PPP.PROJECT_ID(+)
Columns
Name |
PROJECT_ID |
PROJ_ELEMENT_ID |
AS_OF_DATE |