APPS.AP_OPEN_ITEMS_REVAL_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 46: from ap_system_parameters_all asp,

42: ai.payment_status_flag,
43: sum(nvl(xal.entered_cr, 0) - nvl(xal.entered_dr, 0)) entered_amount,
44: sum(nvl(xal.accounted_cr, 0) - nvl(xal.accounted_dr, 0)) accounted_amount,
45: NULL DUE_DATE
46: from ap_system_parameters_all asp,
47: xla_transaction_entities xte,
48: xla_ae_headers xah,
49: xla_ae_lines xal,
50: gl_code_combinations_kfv gcck,

Line 175: from ap_system_parameters_all asp,

171: ac.base_amount check_base_amount,
172: nvl(xal.entered_cr, 0) - nvl(xal.entered_dr, 0) entered_amount,
173: nvl(xal.accounted_cr, 0) - nvl(xal.accounted_dr, 0) accounted_amount,
174: ai.payment_cross_rate_type /*Bug 14136626*/
175: from ap_system_parameters_all asp,
176: ap_invoices_all ai,
177: hz_parties hp,
178: ap_suppliers supp,
179: ap_supplier_sites_all site,

Line 269: from ap_system_parameters_all asp,

265: ac.base_amount check_base_amount,
266: nvl(xdl.unrounded_entered_cr, 0) - nvl(xdl.unrounded_entered_dr, 0) entered_amount,
267: nvl(xdl.unrounded_accounted_cr, 0) - nvl(xdl.unrounded_accounted_dr, 0) accounted_amount,
268: ai.payment_cross_rate_type /*Bug 14136626*/
269: from ap_system_parameters_all asp,
270: ap_invoices_all ai,
271: hz_parties hp,
272: ap_suppliers supp,
273: ap_supplier_sites_all site,

Line 379: from ap_system_parameters_all asp,

375: ai.payment_status_flag,
376: sum(nvl(aid.amount, 0)) entered_amount,
377: sum(nvl(aid.base_amount, nvl(aid.amount, 0))) accounted_amount,
378: NULL due_Date
379: from ap_system_parameters_all asp,
380: ap_invoice_distributions_all aid,
381: ap_invoice_lines_all ail,
382: gl_code_combinations_kfv gcck,
383: ap_invoices_all ai,

Line 469: from ap_system_parameters_all asp,

465: ''Y'' payment_status_flag,
466: -sum(aip.amount) entered_amount,
467: -sum(nvl(aip.payment_base_amount, aip.amount)) accounted_amount,
468: null due_Date
469: from ap_system_parameters_all asp,
470: ap_invoices_all ai,
471: ap_invoice_payments_all aip,
472: ap_checks_all ac,
473: ap_lookup_codes alc,

Line 958: ap_system_parameters_all asp,

954: g_base_min_acct_unit,
955: g_base_currency_desc,
956: g_coa_id
957: from gl_sets_of_books gsob,
958: ap_system_parameters_all asp,
959: fnd_currencies_vl fc
960: where gsob.set_of_books_id = asp.set_of_books_id
961: and fc.currency_code = gsob.currency_code
962: and asp.org_id = P_ORG_ID;