SELECT pap.full_name,
pap.email_address, pap.employee_number,
aeh.invoice_num, aeh.total
total_amount,
aeh.amt_due_employee
personal_amount, aeh.expense_status_code,
aeh.report_header_id,
aeh.employee_id, aeh.org_id, aeh.ROWID,
round((trunc(sysdate)-trunc(aia.creation_date)))days,aia.creation_date
FROM ap_expense_report_headers_all
aeh, per_all_people_f pap,ap_invoices_all aia
WHERE aeh.employee_id = pap.person_id
AND aeh.org_id = p_organization_id
AND AIA.INVOICE_NUM=aeh.invoice_num
AND aeh.amt_due_employee < 0
and aia.AMOUNT_PAID = 0;
Oracle Fusion HCM Online Training
ReplyDeleteOracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad