APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on AP_INVOICES_ALL

Line 336: l_table_name :='AP_INVOICES_ALL';

332:
333: IF p_application_id = 222 then
334: l_table_name :='RA_CUSTOMER_TRX_ALL';
335: ELSIF p_application_id = 200 then
336: l_table_name :='AP_INVOICES_ALL';
337: ELSIF p_application_id = 201 then
338: l_table_name :='PO_HEADERS_ALL';
339: END IF;
340:

Line 2943: FROM ap_invoices_all inv,

2939: ,inv.vendor_site_id BILL_THIRD_PTY_ACCT_SITE_ID
2940: ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
2941: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
2942: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
2943: FROM ap_invoices_all inv,
2944: xla_upgrade_dates upd,
2945: fnd_currencies fnd_curr,
2946: fnd_document_sequences fds,
2947: ap_invoice_lines_all lines,

Line 3811: FROM ap_invoices_all inv,

3807: AND record_type_code = 'MIGRATED'
3808: AND tax_class = 'INPUT') RECOVERY_RATE_ID
3809: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3810: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3811: FROM ap_invoices_all inv,
3812: xla_upgrade_dates upd,
3813: fnd_currencies fnd_curr,
3814: ap_inv_dists_target ap_dists,
3815: ap_inv_dists_target ap_dists1,