Product: | PA - Projects |
---|---|
Description: | All the valid project templates that have been created in Oracle Projects |
Implementation/DBA Data: | APPS.PA_SELECT_TEMPLATE_V |
SELECT PAP.ORG_ID
, PAP.PROJECT_ID
, PAP.SEGMENT1
, PAP.NAME
, PAP.TEMPLATE_FLAG
, PAP.CREATED_FROM_PROJECT_ID
, PAP.CARRYING_OUT_ORGANIZATION_ID
, PAP.DISTRIBUTION_RULE
, PAP.TEMPLATE_START_DATE_ACTIVE
, PAP.TEMPLATE_END_DATE_ACTIVE
, RLA.RESOURCE_LIST_ID
, POU.OPERATING_UNIT
FROM PA_PROJECTS PAP
, PA_RESOURCE_LIST_ASSIGNMENTS RLA
, PA_RESOURCE_LIST_USES RLU
, PA_OPERATING_UNITS_V POU
WHERE PAP.PROJECT_ID = RLA.PROJECT_ID
AND RLU.RESOURCE_LIST_ASSIGNMENT_ID = RLA.RESOURCE_LIST_ASSIGNMENT_ID
AND RLU.DEFAULT_FLAG = 'Y'
AND PAP.ORG_ID = POU.ORG_ID