VIEW: APPS.PA_XLA_CROSSCHARGE_V

Source

View Text - Preformatted

SELECT exp.expenditure_item_id, pp.name || ' (' || pp.segment1 ||')', pt.task_name || ' (' || pt.task_number || ')', exp.expenditure_type, sys.meaning, et.expenditure_category, exp.expenditure_item_date, exp_org.name, prvdr_org.name, rcvr_org.name, pl.meaning from pa_expenditure_items_all exp, pa_expenditures_all pex, pa_tasks pt, pa_projects_all pp, hr_all_organization_units exp_org, hr_all_organization_units prvdr_org, hr_all_organization_units rcvr_org, pa_expenditure_types et, pa_system_linkages sys, pa_lookups pl 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 exp_org.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 prvdr_org.organization_id = exp.CC_PRVDR_ORGANIZATION_ID and rcvr_org.organization_id = exp.CC_RECVR_ORGANIZATION_ID and exp.cc_cross_charge_code = pl.lookup_code and pl.lookup_type = 'CC_CROSS_CHARGE_CODE'

View Text - HTML Formatted

SELECT EXP.EXPENDITURE_ITEM_ID
, PP.NAME || ' (' || PP.SEGMENT1 ||')'
, PT.TASK_NAME || ' (' || PT.TASK_NUMBER || ')'
, EXP.EXPENDITURE_TYPE
, SYS.MEANING
, ET.EXPENDITURE_CATEGORY
, EXP.EXPENDITURE_ITEM_DATE
, EXP_ORG.NAME
, PRVDR_ORG.NAME
, RCVR_ORG.NAME
, PL.MEANING
FROM PA_EXPENDITURE_ITEMS_ALL EXP
, PA_EXPENDITURES_ALL PEX
, PA_TASKS PT
, PA_PROJECTS_ALL PP
, HR_ALL_ORGANIZATION_UNITS EXP_ORG
, HR_ALL_ORGANIZATION_UNITS PRVDR_ORG
, HR_ALL_ORGANIZATION_UNITS RCVR_ORG
, PA_EXPENDITURE_TYPES ET
, PA_SYSTEM_LINKAGES SYS
, PA_LOOKUPS PL
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 EXP_ORG.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 PRVDR_ORG.ORGANIZATION_ID = EXP.CC_PRVDR_ORGANIZATION_ID
AND RCVR_ORG.ORGANIZATION_ID = EXP.CC_RECVR_ORGANIZATION_ID
AND EXP.CC_CROSS_CHARGE_CODE = PL.LOOKUP_CODE
AND PL.LOOKUP_TYPE = 'CC_CROSS_CHARGE_CODE'