View: PA_CE_INVOICES_V

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

View Text

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(+)

Columns