View: PA_PROJECT_RETENTION_V

Product:	PA - Projects
Description:	Stores retention summary balances
Implementation/DBA Data:	APPS.PA_PROJECT_RETENTION_V

View Text

SELECT PC.PROJECT_ID PROJECT_ID
, PC.CUSTOMER_ID CUSTOMER_ID
, R.CUSTOMER_NAME CUSTOMER_NAME
, R.CUSTOMER_NUMBER CUSTOMER_NUMBER
, PC.RETENTION_LEVEL_CODE RETENTION_LEVEL_CODE
, LK.MEANING RETENTION_LEVEL_NAME
, SPR.INVPROC_CURRENCY_CODE INVPROC_CURRENCY_CODE
, SUM(SPR.TOTAL_RETAINED) TOTAL_RETAINED
, SUM(SPR.TOTAL_BILLED) TOTAL_BILLED
, SUM(SPR.TOTAL_WRITEOFF) TOTAL_WRITEOFF
, PC.RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
FROM PA_PROJECT_CUSTOMERS PC
, PA_SUMMARY_PROJECT_RETN SPR
, PA_CUSTOMERS_V R
, PA_LOOKUPS LK
WHERE R.CUSTOMER_ID = PC.CUSTOMER_ID
AND SPR.PROJECT_ID(+) = PC.PROJECT_ID
AND SPR.CUSTOMER_ID (+)= PC.CUSTOMER_ID
AND LK.LOOKUP_TYPE(+) = 'RETENTION_LEVEL'
AND LK.LOOKUP_CODE(+) = DECODE (PC.RETENTION_LEVEL_CODE
, NULL
, 'NO_RETENTION'
, PC.RETENTION_LEVEL_CODE) GROUP BY PC.PROJECT_ID
, PC.CUSTOMER_ID
, R.CUSTOMER_NAME
, R.CUSTOMER_NUMBER
, PC.RETENTION_LEVEL_CODE
, LK.MEANING
, SPR.INVPROC_CURRENCY_CODE
, PC.RECORD_VERSION_NUMBER

Columns