VIEW: APPS.PA_CE_INVOICES_V

Source

View Text - Preformatted

SELECT PA.PROJECT_ID , DII.INV_AMOUNT , DII.AMOUNT , DI.INV_CURRENCY_CODE , PA.PROJECT_CURRENCY_CODE , DI.INVOICE_DATE , DI.ORG_ID , NVL(CP1.PROFILE_CLASS_ID,CP.PROFILE_CLASS_ID) , DII.DRAFT_INVOICE_NUM , DII.LINE_NUM FROM PA_DRAFT_INVOICE_ITEMS DII, HZ_CUST_SITE_USES_ALL SU, HZ_CUSTOMER_PROFILES CP, HZ_CUSTOMER_PROFILES CP1, PA_DRAFT_INVOICES_ALL DI, PA_PROJECTS_ALL PA WHERE DI.PROJECT_ID = PA.PROJECT_ID AND DI.PROJECT_ID = DII.PROJECT_ID AND DI.DRAFT_INVOICE_NUM = DII.DRAFT_INVOICE_NUM AND DI.TRANSFER_STATUS_CODE = 'P' AND DI.RELEASED_DATE IS NOT NULL AND SU.cust_acct_site_id = di.BILL_TO_ADDRESS_ID AND CP.cust_account_id= di.bill_to_CUSTOMER_ID AND CP.SITE_USE_ID IS NULL AND SU.STATUS = 'A' AND SU.SITE_USE_CODE = 'BILL_TO' AND SU.SITE_USE_ID = CP1.SITE_USE_ID(+)

View Text - HTML Formatted

SELECT PA.PROJECT_ID
, DII.INV_AMOUNT
, DII.AMOUNT
, DI.INV_CURRENCY_CODE
, PA.PROJECT_CURRENCY_CODE
, DI.INVOICE_DATE
, DI.ORG_ID
, NVL(CP1.PROFILE_CLASS_ID
, CP.PROFILE_CLASS_ID)
, DII.DRAFT_INVOICE_NUM
, DII.LINE_NUM
FROM PA_DRAFT_INVOICE_ITEMS DII
, HZ_CUST_SITE_USES_ALL SU
, HZ_CUSTOMER_PROFILES CP
, HZ_CUSTOMER_PROFILES CP1
, PA_DRAFT_INVOICES_ALL DI
, PA_PROJECTS_ALL PA
WHERE DI.PROJECT_ID = PA.PROJECT_ID
AND DI.PROJECT_ID = DII.PROJECT_ID
AND DI.DRAFT_INVOICE_NUM = DII.DRAFT_INVOICE_NUM
AND DI.TRANSFER_STATUS_CODE = 'P'
AND DI.RELEASED_DATE IS NOT NULL
AND SU.CUST_ACCT_SITE_ID = DI.BILL_TO_ADDRESS_ID
AND CP.CUST_ACCOUNT_ID= DI.BILL_TO_CUSTOMER_ID
AND CP.SITE_USE_ID IS NULL
AND SU.STATUS = 'A'
AND SU.SITE_USE_CODE = 'BILL_TO'
AND SU.SITE_USE_ID = CP1.SITE_USE_ID(+)