FND Design Data [Home] [Help]

View: PA_PROG_AS_OF_DATES

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.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