VIEW: APPS.PA_PROJECT_RETENTION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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