How to get Itemized Expense Details

Summary:

How to get Itemized Expense Details

Content (please ensure you mask any confidential information):

Hi,

I have a report with expenses using tables like (EXM_EXPENSES, exm_expense_reports, exm_expense_types, EXM_EXPENSE_DISTS, pjc_exp_items_all, ap_invoices_all and ap_invoice_distributions_all).

Now it is showing Project Cost transaction reference for all expense types except "Itemized Expense"

I want to get the Sub Expenses of that expense report id whole expense type is "Itemized Expense".

Can someone please guide me the exact reference/query how to get the child expenses involved in that parent expense report id whole expense type is "Itemized Expense"?