VIEW: APPS.PA_MULTI_CUSTOMERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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