VIEW: APPS.GMS_XLA_PROJECT_REF_V

Source

View Text - Preformatted

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'), P.ORG_ID, 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, PE.EVENT_ID FROM PA_PROJECTS_ALL P, PA_PROJECT_TYPES_ALL PT, HR_ALL_ORGANIZATION_UNITS HROU2, HR_ORGANIZATION_INFORMATION I1, HR_ORGANIZATION_INFORMATION I2, PA_EVENTS PE, GMS_EVENT_ATTRIBUTE GEA 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' AND GEA.PROJECT_ID = PE.PROJECT_ID AND GEA.EVENT_NUM = PE.EVENT_NUM AND P.PROJECT_ID = GEA.ACTUAL_PROJECT_ID AND ROWNUM = 1

View Text - HTML Formatted

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')
, P.ORG_ID
, 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
, PE.EVENT_ID
FROM PA_PROJECTS_ALL P
, PA_PROJECT_TYPES_ALL PT
, HR_ALL_ORGANIZATION_UNITS HROU2
, HR_ORGANIZATION_INFORMATION I1
, HR_ORGANIZATION_INFORMATION I2
, PA_EVENTS PE
, GMS_EVENT_ATTRIBUTE GEA
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'
AND GEA.PROJECT_ID = PE.PROJECT_ID
AND GEA.EVENT_NUM = PE.EVENT_NUM
AND P.PROJECT_ID = GEA.ACTUAL_PROJECT_ID
AND ROWNUM = 1