APPS.AP_WEB_EXPORT_ER dependencies on AP_INVOICES_ALL

Line 84: FROM ap_invoices_all I, ap_invoices_all P, ap_suppliers V,

80: ap_invoices_utility_pkg.get_amt_applied_per_prepay(I.invoice_id,P.invoice_id),
81: aeh.org_id OU_ID,
82: hou.name,
83: aeh.default_currency_code
84: FROM ap_invoices_all I, ap_invoices_all P, ap_suppliers V,
85: ap_expense_report_headers_all aeh, hr_organization_units hou
86: WHERE aeh.request_id = l_req_id
87: AND aeh.vouchno is not null
88: AND hou.organization_id(+) = aeh.org_id

Line 118: ap_invoices_all ai,

114: hou.name,
115: aeh.default_currency_code
116: FROM
117: ap_expense_report_headers_all aeh,
118: ap_invoices_all ai,
119: ap_suppliers aps,
120: ap_suppliers apsbp,
121: per_employees_x per,
122: ap_lookup_codes alc,

Line 152: ap_invoices_all ai,

148: hou.name,
149: aeh.default_currency_code
150: FROM
151: ap_expense_report_headers_all aeh,
152: ap_invoices_all ai,
153: ap_suppliers aps,
154: per_cont_workers_x per,
155: ap_lookup_codes alc,
156: hr_organization_units hou

Line 181: l_invoice_num ap_invoices_all.invoice_num%TYPE;

177: l_inv_date ap_expense_report_headers_all.week_end_date%TYPE;
178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;
179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;
183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;
185: l_inv_remaining NUMBER;

Line 182: l_prepay_num ap_invoices_all.invoice_num%TYPE;

178: l_inv_curr ap_expense_report_headers_all.payment_currency_code%TYPE;
179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;
183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;
185: l_inv_remaining NUMBER;
186: l_prepay_remaining NUMBER;

Line 183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

179: l_inv_amount ap_expense_report_headers_all.total%TYPE;
180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;
183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;
185: l_inv_remaining NUMBER;
186: l_prepay_remaining NUMBER;
187: l_per_prepay NUMBER;

Line 184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;

180: l_reject_reason ap_lookup_codes.description%TYPE;
181: l_invoice_num ap_invoices_all.invoice_num%TYPE;
182: l_prepay_num ap_invoices_all.invoice_num%TYPE;
183: l_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
184: l_inv_amt ap_invoices_all.invoice_amount%TYPE;
185: l_inv_remaining NUMBER;
186: l_prepay_remaining NUMBER;
187: l_per_prepay NUMBER;
188: l_prepay_applied NUMBER;

Line 1387: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai

1383:
1384: CURSOR c_successful_invoices(l_request_id IN NUMBER) IS
1385: SELECT ai.invoice_id, aerh.report_header_id,
1386: aerh.advance_invoice_to_apply, aerh.maximum_amount_to_apply
1387: FROM ap_expense_report_headers_all aerh, ap_invoices_all ai
1388: WHERE ai.APPLICATION_ID = 200
1389: AND ai.PRODUCT_TABLE = 'AP_EXPENSE_REPORT_HEADERS_ALL'
1390: AND ai.REFERENCE_KEY1 = aerh.report_header_id
1391: AND aerh.invoice_num = ai.invoice_num