Query to get Expense Report Information in Fusion Cloud

 -- Query to get Expense report,Expense Item,Template Types and Code combination info

select to_char(EER.EXPENSE_REPORT_ID) EXPENSE_REPORT_ID
,to_char(EER.EXPENSE_REPORT_NUM) EXPENSE_REPORT_NUM
,EER.EXPENSE_REPORT_DATE
,EER.EXPENSE_REPORT_TOTAL
,EER.REPORT_SUBMIT_DATE
,EER.EXPENSE_STATUS_CODE
,EER.PAYMENT_METHOD_CODE
,ET.NAME TEMPLATE_NAME
,eet.name type_name
,ee.expense_id
,ee.person_id
,ee.assignment_id
,ee.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_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 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)