View: PA_XLA_INVOICE_REF_V

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

View Text

SELECT I.PROJECT_ID
, TO_CHAR(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

Columns