View: PA_XLA_PROJECT_REF_V

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

View Text

SELECT P.PROJECT_ID
, P.NAME
, PT.PROJECT_TYPE
, PT.PROJECT_TYPE_CLASS_CODE
, P.SEGMENT1
, P.CARRYING_OUT_ORGANIZATION_ID
, P.LOCATION_ID
, P.PUBLIC_SECTOR_FLAG
, PT.BURDEN_COST_FLAG
, DECODE(NVL(PT.BURDEN_COST_FLAG
, 'N')
, 'Y'
, NVL(PT.BURDEN_AMT_DISPLAY_METHOD
, 'S')
, 'N')
, I1.ORG_INFORMATION3
, I1.ORG_INFORMATION5
, P.ORG_ID
, I2.ORG_INFORMATION3
, I2.ORG_INFORMATION5
, P.ATTRIBUTE_CATEGORY
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE6
, P.ATTRIBUTE7
, P.ATTRIBUTE8
, P.ATTRIBUTE9
, P.ATTRIBUTE10
, PT.ATTRIBUTE_CATEGORY
, PT.ATTRIBUTE1
, PT.ATTRIBUTE2
, PT.ATTRIBUTE3
, PT.ATTRIBUTE4
, PT.ATTRIBUTE5
, PT.ATTRIBUTE6
, PT.ATTRIBUTE7
, PT.ATTRIBUTE8
, PT.ATTRIBUTE9
, PT.ATTRIBUTE10
FROM PA_PROJECTS_ALL P
, PA_PROJECT_TYPES_ALL PT
, HR_ALL_ORGANIZATION_UNITS HROU2
, HR_ORGANIZATION_INFORMATION I1
, HR_ORGANIZATION_INFORMATION I2
WHERE PT.PROJECT_TYPE = P.PROJECT_TYPE
AND PT.ORG_ID = P.ORG_ID
AND HROU2.ORGANIZATION_ID = P.ORG_ID
AND I1.ORGANIZATION_ID (+) = P.CARRYING_OUT_ORGANIZATION_ID
AND I1.ORG_INFORMATION_CONTEXT(+) = 'COMPANY COST CENTER'
AND I2.ORGANIZATION_ID(+) = P.ORG_ID
AND I2.ORG_INFORMATION_CONTEXT(+) = 'COMPANY COST CENTER'

Columns