VIEW: APPS.PA_XLA_INVOICE_REF_V

Source

View Text - Preformatted

SELECT i.Project_ID, i.Draft_invoice_num, 'PROJECTS INVOICES', 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, agr.Agreement_id, agr.customer_id, party.party_name, agr.Agreement_type, agr.Agreement_Num, agr.org_id, agr.attribute_category, agr.Attribute1, agr.Attribute2, agr.Attribute3, agr.Attribute4, agr.Attribute5, agr.Attribute6, agr.Attribute7, agr.Attribute8, agr.Attribute9, agr.Attribute10 from pa_draft_invoices_all i, pa_agreements_all agr, hz_parties party, hz_cust_accounts cust_acct, pa_projects_all p, pa_project_types_all pt, hr_organization_information i1, hr_organization_information i2 WHERE i.project_id = p.project_id and i.agreement_id = agr.agreement_id and pt.project_type = p.project_type and pt.org_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 cust_acct.party_id = party.party_id and cust_acct.cust_account_id = agr.customer_id

View Text - HTML Formatted

SELECT I.PROJECT_ID
, I.DRAFT_INVOICE_NUM
, 'PROJECTS INVOICES'
, 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
, AGR.AGREEMENT_ID
, AGR.CUSTOMER_ID
, PARTY.PARTY_NAME
, AGR.AGREEMENT_TYPE
, AGR.AGREEMENT_NUM
, AGR.ORG_ID
, AGR.ATTRIBUTE_CATEGORY
, AGR.ATTRIBUTE1
, AGR.ATTRIBUTE2
, AGR.ATTRIBUTE3
, AGR.ATTRIBUTE4
, AGR.ATTRIBUTE5
, AGR.ATTRIBUTE6
, AGR.ATTRIBUTE7
, AGR.ATTRIBUTE8
, AGR.ATTRIBUTE9
, AGR.ATTRIBUTE10
FROM PA_DRAFT_INVOICES_ALL I
, PA_AGREEMENTS_ALL AGR
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, PA_PROJECTS_ALL P
, PA_PROJECT_TYPES_ALL PT
, HR_ORGANIZATION_INFORMATION I1
, HR_ORGANIZATION_INFORMATION I2
WHERE I.PROJECT_ID = P.PROJECT_ID
AND I.AGREEMENT_ID = AGR.AGREEMENT_ID
AND PT.PROJECT_TYPE = P.PROJECT_TYPE
AND PT.ORG_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 CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = AGR.CUSTOMER_ID