View: PA_XLA_TASK_REF_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_XLA_TASK_REF_V

View Text

SELECT T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.CARRYING_OUT_ORGANIZATION_ID
, I1.ORG_INFORMATION3
, I1.ORG_INFORMATION5
, T.SERVICE_TYPE_CODE
, T.TOP_TASK_ID
, TT.TASK_NUMBER
, TT.TASK_NAME
, T.BILLABLE_FLAG
, T.RETIREMENT_COST_FLAG
, T.ATTRIBUTE_CATEGORY
, T.ATTRIBUTE1
, T.ATTRIBUTE2
, T.ATTRIBUTE3
, T.ATTRIBUTE4
, T.ATTRIBUTE5
, T.ATTRIBUTE6
, T.ATTRIBUTE7
, T.ATTRIBUTE8
, T.ATTRIBUTE9
, T.ATTRIBUTE10
FROM PA_TASKS T
, PA_TASKS TT
, HR_ORGANIZATION_INFORMATION I1
WHERE TT.TASK_ID = T.TOP_TASK_ID
AND I1.ORGANIZATION_ID (+) = T.CARRYING_OUT_ORGANIZATION_ID
AND I1.ORG_INFORMATION_CONTEXT(+) = 'COMPANY COST CENTER'

Columns