VIEW: APPS.PA_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'), 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'

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')
, 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'