APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on AP_INVOICES_ALL

Line 340: l_table_name :='AP_INVOICES_ALL';

336:
337: IF p_application_id = 222 then
338: l_table_name :='RA_CUSTOMER_TRX_ALL';
339: ELSIF p_application_id = 200 then
340: l_table_name :='AP_INVOICES_ALL';
341: ELSIF p_application_id = 201 then
342: l_table_name :='PO_HEADERS_ALL';
343: END IF;
344:

Line 3004: FROM ap_invoices_all inv,

3000: ,inv.vendor_site_id BILL_THIRD_PTY_ACCT_SITE_ID
3001: ,DECODE(lines.discarded_flag, 'Y', 'Y', 'N') CANCEL_FLAG
3002: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3003: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3004: FROM ap_invoices_all inv,
3005: xla_upgrade_dates upd,
3006: fnd_currencies fnd_curr,
3007: fnd_document_sequences fds,
3008: ap_invoice_lines_all lines,

Line 3897: FROM ap_invoices_all inv,

3893: AND record_type_code = 'MIGRATED'
3894: AND tax_class = 'INPUT') RECOVERY_RATE_ID
3895: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','Y','N') MANUALLY_ENTERED_FLAG --BUG7146063
3896: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3897: FROM ap_invoices_all inv,
3898: xla_upgrade_dates upd,
3899: fnd_currencies fnd_curr,
3900: ap_inv_dists_target ap_dists,
3901: ap_inv_dists_target ap_dists1,