APPS.GMF_AP_GET_INVOICE_PRICE dependencies on AP_INVOICES_ALL

Line 43: ap_invoices_all i,

39: id.last_update_date,
40: id.last_updated_by,
41: i.cancelled_date
42: FROM
43: ap_invoices_all i,
44: ap_invoice_distributions_all id,
45: po_distributions_all pd,
46: cpg_oragems_mapping map,
47: po_lines_all pl,

Line 110: ap_invoices_all i,

106: id.last_update_date,
107: id.last_updated_by,
108: i.cancelled_date
109: FROM
110: ap_invoices_all i,
111: ap_invoice_distributions_all id,
112: po_distributions_all pd,
113: cpg_oragems_mapping map,
114: po_lines_all pl,

Line 306: FROM ap_invoices_all

302:
303: IF tmp_invoice_id IS NOT NULL THEN
304: SELECT invoice_num
305: INTO previous_invoice_num
306: FROM ap_invoices_all
307: WHERE invoice_id = tmp_invoice_id;
308: END IF;
309: /** MC BUG# 1554483 **/
310: OPEN cr_um_code;

Line 321: from ap_holds_all aph, ap_invoices_all api

317:
318: IF invoicenum IS NOT NULL THEN
319: select count(*)
320: into t_hold_count
321: from ap_holds_all aph, ap_invoices_all api
322: where
323: api.invoice_num = invoicenum
324: and api.invoice_id = aph.invoice_id
325: and aph.release_lookup_code is null;

Line 331: from ap_holds_all aph, ap_invoices_all api

327: /* Bug 2539636 : This condition never occurs. Also, this sql is the top one
328: performance repository.
329: select count(*)
330: into t_hold_count
331: from ap_holds_all aph, ap_invoices_all api
332: where
333: api.invoice_id = aph.invoice_id
334: and aph.release_lookup_code is null;
335: */