VIEW: APPS.PA_PROJ_RETN_BILL_VALUES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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