APPS.INL_MATCH_GRP dependencies on AP_INVOICES

Line 265: ap_invoices i,

261: i.exchange_date curr_date,
262: NULL tax_cost_factor_id, --Tax Prorate should be the same basis of its charge
263: 'CHARGE' amount_type
264: FROM inl_matches_int MInt,
265: ap_invoices i,
266: ap_invoice_lines l,
267: ap_invoice_distributions d
268: WHERE MInt.from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'
269: AND MInt.from_parent_table_id = d.invoice_distribution_id

Line 295: ap_invoices i,

291: i.exchange_date curr_date,
292: l_prorat.cost_factor_id tax_cost_factor_id, --Tax Prorate should be the same basis of its charge
293: 'TAX' amount_type
294: FROM inl_matches_int MInt,
295: ap_invoices i,
296: ap_invoice_lines l,
297: ap_invoice_distributions d,
298: ap_invoice_distributions d_prorat,
299: ap_invoice_lines l_prorat

Line 564: ap_invoices i,

560: decode(l.line_type_lookup_code, 'TAX', decode(d.tax_recoverable_flag,'Y',0,d.amount), NULL) nrec_tax_amt,
561: decode(l.line_type_lookup_code, 'TAX', 'N', NULL) tax_amt_included_flag
562: FROM rcv_transactions rt,
563: ap_invoice_distributions d,
564: ap_invoices i,
565: ap_invoice_lines l,
566: mtl_units_of_measure muom
567: WHERE l.line_type_lookup_code IN ('ITEM', 'MISCELLANEOUS', 'FREIGHT', 'TAX')
568: AND d.match_status_flag = 'S'