Oracle Fusion Expense Report Tables and SQL query to fetch Employee Expesne Reports Table

Oracle Fusion Expense Report Tables and SQL query to fetch Employee Expense Reports Table

In this post , I will share the Oracle Cloud Expense report tables and the SQL query to Fetch the Employee's Expense report Information's. In Oracle cloud , Expense Reports tables are changed as compared to Oracle Apps EBS. Please find below the Oracle Fusion Expense Report Tables and SQL query to fetch Employee Expense Reports Table

Oracle Fusion Expense Report Tables

POZ_SUPPLIER_REGISTRATIONS

EXM_EXPENSE_TYPES

EXM_EXPENSE_REPORTS

EXM_EXPENSE_DISTS

EXM_EXPENSES

EXM_EXPENSE_TEMPLATES

 

SQL query to fetch Employee Expense Reports Table

 

Select EER.EXPENSE_REPORT_DATE
,EER.EXPENSE_REPORT_TOTAL
,EER.REPORT_SUBMIT_DATE
,EER.EXPENSE_STATUS_CODE
,EER.PAYMENT_METHOD_CODE
,ET.NAME TEMPLATE_NAME

, EER.EXPENSE_REPORT_ID EXPENSE_REPORT_ID
,EER.EXPENSE_REPORT_NUM EXPENSE_REPORT_NUM
,eet.name type_name

,gcc.segment1
,gcc.segment2
,gcc.segment3
,gcc.segment4
,gcc.segment5
,gcc.segment6
,gcc.segment7
,ee.expense_id
,ee.person_id
,ee.assignment_id
,ee.REIMBURSABLE_AMOUNT
,RECEIPT_AMOUNT
,gcc.code_combination_id
from
exm_expense_reports eer,
EXM_EXPENSES ee,
exm_expense_templates ET,
exm_expense_types eet,
EXM_EXPENSE_DISTS eed,
gl_code_combinations gcc
where 1=1
and ee.expense_report_id =eer.expense_report_id
and eed.expense_id=ee.expense_id
and eed.expense_report_id =ee.expense_report_id
and et.expense_template_id=ee.expense_template_id

And eer.expense_report_num=: EXPENSE_REPORT_NUM
and eet.expense_type_id=ee.expense_type_id
and gcc.code_combination_id=eed.code_combination_id
and gcc.enabled_flag='Y'
order by to_char(EER.EXPENSE_REPORT_ID)