VIEW: APPS.PA_XLA_COST_V

Source

View Text - Preformatted

SELECT exp.expenditure_item_id, pp.name || ' (' || pp.segment1 ||')', pt.task_name || ' (' || pt.task_number || ')', awd.award_short_name || decode(awd.award_short_name, NULL, NULL, ' (') || awd.award_number || decode(awd.award_short_name, NULL, NULL, ')'), exp.expenditure_type, sys.meaning, et.expenditure_category, exp.expenditure_item_date, hr.name, exp.non_labor_resource from pa_expenditure_items_all exp, pa_expenditures_all pex, pa_tasks pt, pa_projects_all pp, gms_award_distributions adl, gms_awards_all awd, hr_all_organization_units hr, pa_expenditure_types et, pa_system_linkages sys WHERE exp.project_id = pp.project_id and exp.project_id = pt.project_id and exp.task_id = pt.task_id and exp.expenditure_id = pex.expenditure_id and hr.organization_id = nvl(exp.override_to_organization_id, incurred_by_organization_id) and exp.expenditure_type = et.expenditure_type and exp.system_linkage_function = sys.function and exp.expenditure_item_id = adl.expenditure_item_id (+) and adl.document_type(+) = 'EXP' and adl.award_id = awd.award_id (+) and adl.adl_line_num(+) = 1 and adl.adl_status(+) = 'A'

View Text - HTML Formatted

SELECT EXP.EXPENDITURE_ITEM_ID
, PP.NAME || ' (' || PP.SEGMENT1 ||')'
, PT.TASK_NAME || ' (' || PT.TASK_NUMBER || ')'
, AWD.AWARD_SHORT_NAME || DECODE(AWD.AWARD_SHORT_NAME
, NULL
, NULL
, ' (') || AWD.AWARD_NUMBER || DECODE(AWD.AWARD_SHORT_NAME
, NULL
, NULL
, ')')
, EXP.EXPENDITURE_TYPE
, SYS.MEANING
, ET.EXPENDITURE_CATEGORY
, EXP.EXPENDITURE_ITEM_DATE
, HR.NAME
, EXP.NON_LABOR_RESOURCE
FROM PA_EXPENDITURE_ITEMS_ALL EXP
, PA_EXPENDITURES_ALL PEX
, PA_TASKS PT
, PA_PROJECTS_ALL PP
, GMS_AWARD_DISTRIBUTIONS ADL
, GMS_AWARDS_ALL AWD
, HR_ALL_ORGANIZATION_UNITS HR
, PA_EXPENDITURE_TYPES ET
, PA_SYSTEM_LINKAGES SYS
WHERE EXP.PROJECT_ID = PP.PROJECT_ID
AND EXP.PROJECT_ID = PT.PROJECT_ID
AND EXP.TASK_ID = PT.TASK_ID
AND EXP.EXPENDITURE_ID = PEX.EXPENDITURE_ID
AND HR.ORGANIZATION_ID = NVL(EXP.OVERRIDE_TO_ORGANIZATION_ID
, INCURRED_BY_ORGANIZATION_ID)
AND EXP.EXPENDITURE_TYPE = ET.EXPENDITURE_TYPE
AND EXP.SYSTEM_LINKAGE_FUNCTION = SYS.FUNCTION
AND EXP.EXPENDITURE_ITEM_ID = ADL.EXPENDITURE_ITEM_ID (+)
AND ADL.DOCUMENT_TYPE(+) = 'EXP'
AND ADL.AWARD_ID = AWD.AWARD_ID (+)
AND ADL.ADL_LINE_NUM(+) = 1
AND ADL.ADL_STATUS(+) = 'A'