eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_XLA_TASK_REF_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'