VIEW: APPS.PA_PLM_PROJECTS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)