Product: | PA - Projects |
---|---|
Description: | View All Project Details |
Implementation/DBA Data: | Not implemented in this database |
SELECT PRJ.PROJECT_ID
, PRJ.SEGMENT1
, PRJ.NAME
, PRJ.DESCRIPTION
, PRJ.START_DATE
, PRJ.COMPLETION_DATE
, PTY.PARTY_ID
, PTY.PARTY_NAME
, NVL(PTY1.PARTY_ID
, -999)
, PTY1.PARTY_NAME
, NVL(USR.USER_ID
, -999)
, USR.USER_NAME
, PPR.PROGRESS_STATUS_CODE
, PAL.MEANING
, PAL.PREDEFINED_FLAG
, PAL.ATTRIBUTE1
, PPR.PROGRESS_ASOF_DATE
, PPR.SHORT_DESCRIPTION
, PPR.LONG_DESCRIPTION
, PPR.ISSUES
, PPR.WF_STATUS_CODE
, PPR.WF_ITEM_TYPE
, PPR.WF_ITEM_KEY
, PPR.WF_PROCESS
, PRJ.ATTRIBUTE1
, PRJ.ATTRIBUTE2
FROM PA_PROJECTS_ALL PRJ
, HZ_PARTIES PTY
, PA_PROJECT_PLAYERS PLAY
, HZ_PARTIES PTY1
, FND_USER USR
, PA_PROJ_PROGRESS_REPORTS PPR
, PA_LOOKUPS PAL
WHERE PTY.PARTY_ID = PRJ.CARRYING_OUT_ORGANIZATION_ID
AND PLAY.PROJECT_ID (+) = PRJ.PROJECT_ID
AND PLAY.PROJECT_ROLE_TYPE (+) = 'PROJECT MANAGER'
AND TRUNC(PLAY.START_DATE_ACTIVE (+)) <= TRUNC(SYSDATE)
AND TRUNC(NVL(PLAY.END_DATE_ACTIVE (+)
, SYSDATE)) >= TRUNC(SYSDATE)
AND PTY1.PARTY_ID (+) = PLAY.PERSON_ID
AND USR.CUSTOMER_ID (+) = PLAY.PERSON_ID
AND PPR.PROJECT_ID = PRJ.PROJECT_ID
AND PPR.TASK_ID = 0
AND PAL.LOOKUP_CODE = PPR.PROGRESS_STATUS_CODE
AND PAL.LOOKUP_TYPE = 'PA_XC_PROGRESS_STATUS'