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;
Whoa! This blog looks exactly like my old one! It's on a totally different subject but it has pretty much the same layout and design. Superb choice of colors!Functional Support
ReplyDeleteOracle Fusion HCM Online Training
ReplyDeleteOracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad