View: PA_MULTI_CUSTOMERS_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_MULTI_CUSTOMERS_V

View Text

SELECT I.ROWID ROW_ID
, I.PROJECT_ID
, I.DRAFT_INVOICE_NUM
, I.DRAFT_INVOICE_NUM_CREDITED
, I.INVOICE_SET_ID
, I.RA_INVOICE_NUMBER
, I.INVOICE_DATE
, I.LAST_UPDATE_DATE
, I.LAST_UPDATED_BY
, I.TRANSFER_STATUS_CODE
, I.GENERATION_ERROR_FLAG
, I.AGREEMENT_ID
, I.PA_DATE
, I.CUSTOMER_BILL_SPLIT
, I.BILL_THROUGH_DATE
, I.INVOICE_COMMENT
, I.APPROVED_DATE
, I.APPROVED_BY_PERSON_ID
, I.RELEASED_DATE
, I.RELEASED_BY_PERSON_ID
, I.TRANSFERRED_DATE
, I.TRANSFER_REJECTION_REASON
, I.UNEARNED_REVENUE_CR
, I.UNBILLED_RECEIVABLE_DR
, I.GL_DATE
, I.SYSTEM_REFERENCE
, I.CANCELED_FLAG
, I.CANCEL_CREDIT_MEMO_FLAG
, I.WRITE_OFF_FLAG
, I.CONVERTED_FLAG
, I.EXTRACTED_DATE
, I.LAST_UPDATE_LOGIN
, I.ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1
, I.ATTRIBUTE2
, I.ATTRIBUTE3
, I.ATTRIBUTE4
, I.ATTRIBUTE5
, I.ATTRIBUTE6
, I.ATTRIBUTE7
, I.ATTRIBUTE8
, I.ATTRIBUTE9
, I.ATTRIBUTE10
, I.RETENTION_PERCENTAGE
, A.CUSTOMER_ID
, HZ_P.PARTY_NAME
, HZ_P.PARTY_NUMBER
, A.AGREEMENT_NUM
, SUM(II.AMOUNT) INVOICE_AMOUNT
FROM HZ_PARTIES HZ_P
, HZ_CUST_ACCOUNTS_ALL HZ_C
, PA_AGREEMENTS_ALL A
, PA_DRAFT_INVOICE_ITEMS II
, PA_DRAFT_INVOICES I
WHERE I.PROJECT_ID = II.PROJECT_ID
AND I.DRAFT_INVOICE_NUM = II.DRAFT_INVOICE_NUM
AND I.AGREEMENT_ID+0 = A.AGREEMENT_ID
AND A.CUSTOMER_ID = HZ_C.CUST_ACCOUNT_ID
AND A.ORG_ID = HZ_C.ORG_ID
AND HZ_C.PARTY_ID = HZ_P.PARTY_ID GROUP BY I.ROWID
, I.PROJECT_ID
, I.DRAFT_INVOICE_NUM
, I.DRAFT_INVOICE_NUM_CREDITED
, I.INVOICE_SET_ID
, I.RA_INVOICE_NUMBER
, I.INVOICE_DATE
, I.LAST_UPDATE_DATE
, I.LAST_UPDATED_BY
, I.TRANSFER_STATUS_CODE
, I.GENERATION_ERROR_FLAG
, I.AGREEMENT_ID
, I.PA_DATE
, I.CUSTOMER_BILL_SPLIT
, I.BILL_THROUGH_DATE
, I.INVOICE_COMMENT
, I.APPROVED_DATE
, I.APPROVED_BY_PERSON_ID
, I.RELEASED_DATE
, I.RELEASED_BY_PERSON_ID
, I.TRANSFERRED_DATE
, I.TRANSFER_REJECTION_REASON
, I.UNEARNED_REVENUE_CR
, I.UNBILLED_RECEIVABLE_DR
, I.GL_DATE
, I.SYSTEM_REFERENCE
, I.CANCELED_FLAG
, I.CANCEL_CREDIT_MEMO_FLAG
, I.WRITE_OFF_FLAG
, I.CONVERTED_FLAG
, I.EXTRACTED_DATE
, I.LAST_UPDATE_LOGIN
, I.ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1
, I.ATTRIBUTE2
, I.ATTRIBUTE3
, I.ATTRIBUTE4
, I.ATTRIBUTE5
, I.ATTRIBUTE6
, I.ATTRIBUTE7
, I.ATTRIBUTE8
, I.ATTRIBUTE9
, I.ATTRIBUTE10
, I.RETENTION_PERCENTAGE
, A.CUSTOMER_ID
, HZ_P.PARTY_NAME
, HZ_P.PARTY_NUMBER
, A.AGREEMENT_NUM

Columns