VIEW: APPS.PA_PROJECTS_BASIC_V

Source

View Text - Preformatted

SELECT P.ORG_ID , P.PROJECT_ID , P.SEGMENT1 , P.NAME , P.LONG_NAME , pou.operating_unit , PT.PROJECT_TYPE_CLASS_CODE , P.PROJECT_STATUS_CODE , NVL(P.TEMPLATE_FLAG,'N') , P.PM_PROJECT_REFERENCE , P.SEGMENT1 , P.PROJECT_CURRENCY_CODE , PT.CC_PRVDR_FLAG , P.BASELINE_FUNDING_FLAG , P.revaluate_funding_flag FROM PA_PROJECT_TYPES PT , PA_PROJECTS_ALL P , PA_OPERATING_UNITS_V POU , HR_ORGANIZATION_UNITS ORG WHERE 'Y' IN (SELECT PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID) FROM SYS.DUAL) AND P.PROJECT_TYPE = PT.PROJECT_TYPE AND PT.project_type <> 'AWARD_PROJECT' AND P.CARRYING_OUT_ORGANIZATION_ID=ORG.ORGANIZATION_ID AND PT.ORG_ID = P.ORG_ID AND POU.ORG_ID = P.ORG_ID

View Text - HTML Formatted

SELECT P.ORG_ID
, P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, P.LONG_NAME
, POU.OPERATING_UNIT
, PT.PROJECT_TYPE_CLASS_CODE
, P.PROJECT_STATUS_CODE
, NVL(P.TEMPLATE_FLAG
, 'N')
, P.PM_PROJECT_REFERENCE
, P.SEGMENT1
, P.PROJECT_CURRENCY_CODE
, PT.CC_PRVDR_FLAG
, P.BASELINE_FUNDING_FLAG
, P.REVALUATE_FUNDING_FLAG
FROM PA_PROJECT_TYPES PT
, PA_PROJECTS_ALL P
, PA_OPERATING_UNITS_V POU
, HR_ORGANIZATION_UNITS ORG
WHERE 'Y' IN (SELECT PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
FROM SYS.DUAL)
AND P.PROJECT_TYPE = PT.PROJECT_TYPE
AND PT.PROJECT_TYPE <> 'AWARD_PROJECT'
AND P.CARRYING_OUT_ORGANIZATION_ID=ORG.ORGANIZATION_ID
AND PT.ORG_ID = P.ORG_ID
AND POU.ORG_ID = P.ORG_ID