VIEW: APPS.PA_XLA_EXP_HEADER_V

Source

View Text - Preformatted

SELECT xev.event_id, xev.source_id_int_1, xev.event_date, ei.project_id, ei.task_id, ei.expenditure_type, nvl(ei.override_to_organization_id, e.incurred_by_organization_id), ei.org_id, e.incurred_by_person_id, ei.expenditure_id, e.expenditure_class_code, ei.expenditure_item_date, ei.Orig_transaction_reference, e.ORIG_USER_EXP_TXN_REFERENCE, e.Orig_exp_txn_reference1, e.Orig_exp_txn_reference2, e.Orig_exp_txn_reference3, ei.inventory_item_id, ei.wip_resource_id, ei.non_labor_resource, ei.organization_id, ei.system_linkage_function, ei.source_expenditure_item_id, nvl(e.person_type,'EMP'), ei.cost_job_id, ei.job_id, ei.transaction_source, decode(ei.transaction_source,'AP ERV', 'Y', 'N'), ei.adjusted_expenditure_item_id, ei.cc_prvdr_organization_id, ei.override_to_organization_id, ei.tp_job_id, ei.tp_amt_type_code, ei.cc_cross_charge_type, ei.Labor_Cost_Multiplier_Name, ei.attribute_category, ei.attribute1, ei.attribute2, ei.attribute3, ei.attribute4, ei.attribute5, ei.attribute6, ei.attribute7, ei.attribute8, ei.attribute9, ei.attribute10, e.attribute_category, e.attribute1, e.attribute2, e.attribute3, e.attribute4, e.attribute5, e.attribute6, e.attribute7, e.attribute8, e.attribute9, e.attribute10 from xla_events_gt xev, pa_expenditure_items_all ei, pa_expenditures_all e WHERE xev.application_id = 275 and e.expenditure_id = ei.expenditure_id and ei.expenditure_item_id = xev.source_id_int_1

View Text - HTML Formatted

SELECT XEV.EVENT_ID
, XEV.SOURCE_ID_INT_1
, XEV.EVENT_DATE
, EI.PROJECT_ID
, EI.TASK_ID
, EI.EXPENDITURE_TYPE
, NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)
, EI.ORG_ID
, E.INCURRED_BY_PERSON_ID
, EI.EXPENDITURE_ID
, E.EXPENDITURE_CLASS_CODE
, EI.EXPENDITURE_ITEM_DATE
, EI.ORIG_TRANSACTION_REFERENCE
, E.ORIG_USER_EXP_TXN_REFERENCE
, E.ORIG_EXP_TXN_REFERENCE1
, E.ORIG_EXP_TXN_REFERENCE2
, E.ORIG_EXP_TXN_REFERENCE3
, EI.INVENTORY_ITEM_ID
, EI.WIP_RESOURCE_ID
, EI.NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID
, EI.SYSTEM_LINKAGE_FUNCTION
, EI.SOURCE_EXPENDITURE_ITEM_ID
, NVL(E.PERSON_TYPE
, 'EMP')
, EI.COST_JOB_ID
, EI.JOB_ID
, EI.TRANSACTION_SOURCE
, DECODE(EI.TRANSACTION_SOURCE
, 'AP ERV'
, 'Y'
, 'N')
, EI.ADJUSTED_EXPENDITURE_ITEM_ID
, EI.CC_PRVDR_ORGANIZATION_ID
, EI.OVERRIDE_TO_ORGANIZATION_ID
, EI.TP_JOB_ID
, EI.TP_AMT_TYPE_CODE
, EI.CC_CROSS_CHARGE_TYPE
, EI.LABOR_COST_MULTIPLIER_NAME
, EI.ATTRIBUTE_CATEGORY
, EI.ATTRIBUTE1
, EI.ATTRIBUTE2
, EI.ATTRIBUTE3
, EI.ATTRIBUTE4
, EI.ATTRIBUTE5
, EI.ATTRIBUTE6
, EI.ATTRIBUTE7
, EI.ATTRIBUTE8
, EI.ATTRIBUTE9
, EI.ATTRIBUTE10
, E.ATTRIBUTE_CATEGORY
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
FROM XLA_EVENTS_GT XEV
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL E
WHERE XEV.APPLICATION_ID = 275
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND EI.EXPENDITURE_ITEM_ID = XEV.SOURCE_ID_INT_1