[Home] [Help]
View: PA_TASK_BILLING_INFO_V
Product: | PA - Projects |
Description: | PA_TASK_BILLING_INFO_V provides the billing information for tasks. |
Implementation/DBA Data: |
APPS.PA_TASK_BILLING_INFO_V
|
View Text
SELECT PT.ROWID
, PT.TASK_ID
, PT.REVENUE_ACCRUAL_METHOD
, LKP1.MEANING
, PT.INVOICE_METHOD
, LKP2.MEANING
, PT.PROJECT_ID
FROM PA_TASKS PT
, PA_LOOKUPS LKP1
, PA_LOOKUPS LKP2
WHERE LKP1.LOOKUP_TYPE = 'REVENUE ACCRUAL METHOD'
AND LKP2.LOOKUP_TYPE = 'INVOICE METHOD'
AND LKP1.LOOKUP_CODE = PT.REVENUE_ACCRUAL_METHOD
AND LKP2.LOOKUP_CODE = PT.INVOICE_METHOD
Columns
Name |
ROW_ID |
TASK_ID |
REVENUE_ACCRUAL_METHOD |
REVENUE_ACCRUAL_METHOD_M |
INVOICE_METHOD |
INVOICE_METHOD_M |
PROJECT_ID |