Query to Find NonBillable Expense in Oracle Fusion
SELECT pcdl.prvdr_gl_period_name gl_period, trx_org.NAME expenditure_organization, prb.project_id, NVL (prb.segment1, ‘N/A’) project_number, NVL (prl.NAME, ‘N/A’) project_name, NULL project_type_class_code, ppn.full_name employee_vendor, papf.person_number employee_number, ptv.task_name, pec.expenditure_category_name expenditure_category, pet.expenditure_type_name expenditure_type, pcdl.prvdr_gl_date week_ending, pei.expenditure_item_date expenditure_date, pcdl.denom_currency_code…
Read More