Expense Report Tables in Oracle Fusion : Oracle Fusion Expense Report SQL Query

Expense Report Tables in Oracle Fusion : Oracle Fusion Expense Report SQL Query

In this post , We will discuss about Expense Report Tables in Oracle Fusion. In Oracle fusion , Expense report tables have been changed as compared to the Oracle apps r12 Expense report Tables. In this post , you will get the list of the Expense Report Tables in Oracle Fusion and the SQL query too which helps to fetch the Expense reports information's in Oracle Fusion. 

 

5 Important Expense Report Tables in Oracle Fusion

EXM_EXPENSE_TYPES

EXM_EXPENSES_REPORTS
EXM_EXPENSES
EXM_EX_EXPXPENSE_TEMPLATES
EXM_EXPENSE_DISTS
GL_CODE_COMBINATIONS    

 

Oracle Fusion Expense Report SQL Query

select to_char(EX_REPORT.EXPENSE_REPORT_ID) EXPENSE_REPORT_ID
,to_char(EX_REPORT.EXPENSE_REPORT_NUM) EXPENSE_REPORT_NUM
,EX_REPORT.EXPENSE_REPORT_DATE
,EX_REPORT.EXPENSE_REPORT_TOTAL
,EX_REPORT.REPORT_SUBMIT_DATE
,EX_REPORT.EXPENSE_STATUS_CODE
,EX_REPORT.PAYMENT_METHOD_CODE
,ET.NAME TEMPLATE_NAME
,EX_TYPE.name type_name
,EX_EXP.expense_id
,EX_EXP.person_id
,EX_EXP.assignment_id
,EX_EXP.REIMBURSABLE_AMOUNT
,RECEIPT_AMOUNT
,gcc.code_combination_id
,gcc.segment1
,gcc.segment2
,gcc.segment3
,gcc.segment4
,gcc.segment5
,gcc.segment6
,gcc.segment7
from
EXM_EXPENSE_TYPES EX_TYPE,

EXM_EXPENSES_REPORTS EX_REPORT,
EXM_EXPENSES EX_EXP,
EXM_EX_EXPXPENSE_TEMPLATES ET,
EXM_EXPENSE_DISTS EX_EXPD,
GL_CODE_COMBINATIONS GCC
where 1=1
and EX_EXP.expense_report_id =EX_REPORT.expense_report_id
and EX_EXPd.expense_id=EX_EXP.expense_id
and EX_EXPd.expense_report_id =EX_EXP.expense_report_id
and et.expense_template_id=EX_EXP.expense_template_id
and EX_TYPE.expense_type_id=EX_EXP.expense_type_id
and gcc.code_combination_id=EX_EXPd.code_combination_id
and gcc.enabled_flag='Y'