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