PJC_XLA_EXP_HEADER_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name

EVENT_ID EXPENDITURE_ITEM_ID ACCOUNTING_DATE PROJECT_ID TASK_ID EXPENDITURE_TYPE_ID EXPENDITURE_ORGANIZATION_ID EXPENDITURE_BU_ID EXPENDITURE_BU_NAME PERSON_ID EXPENDITURE_ITEM_DATE NON_LABOR_RESOURCE NON_LABOR_RESOURCE_ID NL_RES_ORGANIZATION_ID NL_RES_ORGANIZATION_NAME SYSTEM_LINKAGE_FUNCTION HCM_PERSON_TYPE COST_JOB_ID PERSON_JOB_ID ADJ_EXPENDITURE_ITEM_ID CC_PRVDR_ORGANIZATION_ID CC_PRVDR_ORGANIZATION_NAME OVERRIDE_TO_ORG_ID OVERRIDE_TO_ORG_NAME TP_JOB_ID TP_AMT_TYPE_CODE CC_CROSS_CHARGE_TYPE LABOR_COST_MULTIPLIER_NAME DOCUMENT_ID TRANSACTION_SOURCE_ID PEI_ATTRIBUTE_CATEGORY PEI_ATTRIBUTE1 PEI_ATTRIBUTE2 PEI_ATTRIBUTE3 PEI_ATTRIBUTE4 PEI_ATTRIBUTE5 PEI_ATTRIBUTE6 PEI_ATTRIBUTE7 PEI_ATTRIBUTE8 PEI_ATTRIBUTE9 PEI_ATTRIBUTE10 RBS_ELEMENT_ID PROJECT_UNIT_ID BILLABLE_FLAG WORK_TYPE_ID WORK_TYPE_NAME INVENTORY_ITEM_ID ORIG_EXP_ITEM_TXN_REFERENCE CONTEXT_CATEGORY USER_DEF_ATTRIBUTE1 USER_DEF_ATTRIBUTE2 USER_DEF_ATTRIBUTE3 USER_DEF_ATTRIBUTE4 USER_DEF_ATTRIBUTE5 USER_DEF_ATTRIBUTE6 USER_DEF_ATTRIBUTE7 USER_DEF_ATTRIBUTE8 USER_DEF_ATTRIBUTE9 USER_DEF_ATTRIBUTE10 DOC_ENTRY_ID BILLING_RBS_ELEMENT_ID IC_BILLABLE_FLAG HCM_ASSIGNMENT_ID CONTRACT_ID CONTRACT_LINE_ID FUNDING_ALLOCATION_ID FUNDING_SOURCE_ID FUNDING_SOURCE_NUMBER FUNDING_SOURCE_NAME TRANSFERRED_FROM_EXP_ITEM_ID VENDOR_ID PO_LINE_ID EXPENDITURE_BATCH USER_EXPENDITURE_BATCH EXP_ITEM_CREATION_DATE EXP_ITEM_LAST_UPDATED_BY EXP_ITEM_CREATED_BY EXP_ITEM_LAST_UPDATED_DATE EXPENDITURE_COMMENT PAY_ELEMENT_TYPE COST_ALLOCATION_KEYFLEX_ID COST_ID PAYROLL_ID RUN_ID RUN_ACTION_ID COST_ACTION_ID PAYROLL_NAME COST_ACTION_TYPE REPROCESS_FLAG

Query

SQL_Statement

SELECT xev.event_id , xev.source_id_int_1 expenditure_item_id , xev.event_date accounting_date , ei.project_id , ei.task_id , ei.expenditure_type_id , ei.expenditure_organization_id, ei.org_id expenditure_bu_id , ei.org_id EXPENDITURE_BU_NAME, ei.incurred_by_person_id person_id , ei.expenditure_item_date , ei.non_labor_resource_id non_labor_resource , ei.non_labor_resource_id , ei.non_labor_resource_org_id nl_res_organization_id , ei.non_labor_resource_org_id nl_res_organization_name , ei.system_linkage_function , NVL(ei.person_type, 'EMP') HCM_PERSON_TYPE , ei.cost_job_id , ei.person_job_id , ei.adjusted_expenditure_item_id adj_expenditure_item_id, ei.cc_prvdr_organization_id , ei.cc_prvdr_organization_id cc_prvdr_organization_name , ei.override_to_organization_id override_to_org_id , ei.override_to_organization_id override_to_org_name , ei.tp_job_id , ei.tp_amt_type_code , ei.cc_cross_charge_type , ei.labor_cost_multiplier_name , ei.document_id , ei.transaction_source_id , ei.attribute_category pei_attribute_category , ei.attribute1 pei_attribute1 , ei.attribute2 pei_attribute2 , ei.attribute3 pei_attribute3 , ei.attribute4 pei_attribute4 , ei.attribute5 pei_attribute5 , ei.attribute6 pei_attribute6 , ei.attribute7 pei_attribute7 , ei.attribute8 pei_attribute8 , ei.attribute9 pei_attribute9 , ei.attribute10 pei_attribute10 , ei.rbs_element_id , ei.project_unit_id , ei.billable_flag , ei.work_type_id work_type_id , ei.work_type_id work_type_name , ei.inventory_item_id inventory_item_id , ei.orig_transaction_reference orig_exp_item_txn_reference , ei.context_category , ei.user_def_attribute1 , ei.user_def_attribute2 , ei.user_def_attribute3 , ei.user_def_attribute4 , ei.user_def_attribute5 , ei.user_def_attribute6 , ei.user_def_attribute7 , ei.user_def_attribute8 , ei.user_def_attribute9 , ei.user_def_attribute10, ei.doc_entry_id, ei.ic_rbs_element_id as billing_rbs_element_id, ei.ic_billable_flag, ei.hcm_assignment_id, ei.CONTRACT_ID, ei.CONTRACT_LINE_ID, ei.FUNDING_ALLOCATION_ID, ei.RESERVED_ATTRIBUTE1 FUNDING_SOURCE_ID, to_number(ei.RESERVED_ATTRIBUTE1) FUNDING_SOURCE_NUMBER, to_number(ei.RESERVED_ATTRIBUTE1) FUNDING_SOURCE_NAME, ei.TRANSFERRED_FROM_EXP_ITEM_ID TRANSFERRED_FROM_EXP_ITEM_ID, ei.vendor_id VENDOR_ID, ei.PARENT_LINE_NUMBER PO_LINE_ID, eigroup.EXPENDITURE_GROUP EXPENDITURE_BATCH, eigroup.USER_BATCH_NAME USER_EXPENDITURE_BATCH, trunc(ei.creation_date) EXP_ITEM_CREATION_DATE, ei.LAST_UPDATED_BY EXP_ITEM_LAST_UPDATED_BY, ei.CREATED_BY EXP_ITEM_CREATED_BY, trunc(ei.LAST_UPDATE_DATE) EXP_ITEM_LAST_UPDATED_DATE, ec.expenditure_Comment EXPENDITURE_COMMENT, ei.REFERENCE_ID3 PAY_ELEMENT_TYPE, ei.COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID, ei.COST_ID COST_ID, ei.REFERENCE_ID7 PAYROLL_ID, ei.REFERENCE_ID8 RUN_ID, ei.REFERENCE_ID9 RUN_ACTION_ID, ei.REFERENCE_ID10 COST_ACTION_ID, ei.DOC_REF_ID7 PAYROLL_NAME, ei.DOC_REF_ID8 COST_ACTION_TYPE, ei.DOC_REF_ID10 as reprocess_flag FROM xla_events_gt xev, pjc_exp_items_all ei, PJC_EXP_GROUPS_ALL eigroup, pjc_Exp_comments ec WHERE xev.application_id = 10036 AND ei.expenditure_item_id = xev.source_id_int_1 AND eigroup.EXP_GROUP_ID = ei.EXP_GROUP_ID AND ei.expenditure_item_id= ec.expenditure_item_id(+)