[Home] [Help]
View: PA_PROJ_RETN_BILL_RULES_V
Product: | PA - Projects |
Description: | PA_PROJ_RETN_BILL_RULES stores retention billing rules for a
project or top task. Retention invoice is generated based on these rules |
Implementation/DBA Data: |
APPS.PA_PROJ_RETN_BILL_RULES_V
|
View Text
SELECT BILLING_METHOD_CODE
, PROJECT_ID
, CUSTOMER_ID
, TASK_ID
, TOTAL_RETENTION_AMOUNT
, CLIENT_EXTENSION_FLAG
, RETN_BILLING_PERCENTAGE
, RETN_BILLING_AMOUNT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, COMPLETED_PERCENTAGE
, RETN_BILLING_CYCLE_ID
, RETN_BILLING_RULE_ID
FROM PA_PROJ_RETN_BILL_RULES
Columns
Name |
BILLING_METHOD_CODE |
PROJECT_ID |
CUSTOMER_ID |
TASK_ID |
TOTAL_RETENTION_AMOUNT |
CLIENT_EXTENSION_FLAG |
RETN_BILLING_PERCENTAGE |
RETN_BILLING_AMOUNT |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
COMPLETED_PERCENTAGE |
RETN_BILLING_CYCLE_ID |
RETN_BILLING_RULE_ID |