View: PA_PLM_PROJECTS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PLM_PROJECTS_V

View Text

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.LONG_NAME
, PPA.SEGMENT1
, PPA.PROJECT_TYPE
, PPA.CARRYING_OUT_ORGANIZATION_ID
, PPA.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPA.DESCRIPTION
, PPA.TEMPLATE_FLAG
, PPA.ORG_ID
, PPA.PROJECT_CURRENCY_CODE
, PARTIES.RESOURCE_SOURCE_ID
, PEOPLE.FULL_NAME
, PR.PROGRESS_STATUS_CODE
, PR.PROGRESS_STATUS_NAME
, PR.STATUS_ICON_IND
, PR.STATUS_ICON_ACTIVE_IND
FROM PA_PROJECTS_SEC_V PPA
, PA_PROJECT_STATUSES PPS
, PER_ALL_PEOPLE_F PEOPLE
, PA_PROJECT_PARTIES PARTIES
, PA_PROJ_CURR_STATUS_REP_V PR
WHERE PPA.TEMPLATE_FLAG = 'N'
AND PPA.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PARTIES.PROJECT_ROLE_ID (+) = 1
AND PARTIES.PROJECT_ID (+) = PPA.PROJECT_ID
AND SYSDATE BETWEEN PARTIES.START_DATE_ACTIVE(+)
AND NVL(PARTIES.END_DATE_ACTIVE(+)
, SYSDATE + 1)
AND PARTIES.RESOURCE_SOURCE_ID = PEOPLE.PERSON_ID (+)
AND PPA.PROJECT_ID = PR.PROJECT_ID (+)
AND SYSDATE BETWEEN PEOPLE.EFFECTIVE_START_DATE (+)
AND PEOPLE.EFFECTIVE_END_DATE (+)

Columns