View: PA_PROJ_RETN_BILL_VALUES_V

Product:	PA - Projects
Description:	PA_PROJ_RETN_BILL_VALUES is a view that used for displaying Billing Retentions in Summary page
Implementation/DBA Data:	APPS.PA_PROJ_RETN_BILL_VALUES_V

View Text

SELECT BL.RETN_BILLING_RULE_ID
, BL.PROJECT_ID
, BL.CUSTOMER_ID
, BL.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, BL.BILLING_METHOD_CODE
, FD.MEANING BILLING_METHOD
, DECODE(BL.BILLING_METHOD_CODE
, 'CLIENT_EXTENSION'
, CLIENT_EXTENSION_FLAG
, 'PERCENT_COMPLETE'
, COMPLETED_PERCENTAGE
, 'TOTAL_RETENTION_AMOUNT'
, TOTAL_RETENTION_AMOUNT ) METHOD_VALUE
, RETN_BILLING_PERCENTAGE
, RETN_BILLING_AMOUNT
FROM PA_PROJ_RETN_BILL_RULES BL
, PA_LOOKUPS FD
, PA_TASKS T
WHERE FD.LOOKUP_TYPE = 'RETN_BILLING_METHOD'
AND FD.LOOKUP_CODE = BL.BILLING_METHOD_CODE
AND T.TASK_ID (+) = BL.TASK_ID
AND BL.RETN_BILLING_CYCLE_ID IS NULL UNION SELECT BL.RETN_BILLING_RULE_ID
, BL.PROJECT_ID
, BL.CUSTOMER_ID
, BL.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, BL.BILLING_METHOD_CODE
, FD.MEANING BILLING_METHOD
, C.BILLING_CYCLE_NAME METHOD_VALUE
, RETN_BILLING_PERCENTAGE
, RETN_BILLING_AMOUNT
FROM PA_PROJ_RETN_BILL_RULES BL
, PA_LOOKUPS FD
, PA_BILLING_CYCLES C
, PA_TASKS T
WHERE FD.LOOKUP_TYPE = 'RETN_BILLING_METHOD'
AND FD.LOOKUP_CODE = BL.BILLING_METHOD_CODE
AND C.BILLING_CYCLE_ID (+)= BL.RETN_BILLING_CYCLE_ID
AND T.TASK_ID (+) = BL.TASK_ID
AND BL.RETN_BILLING_CYCLE_ID IS NOT NULL

Columns