APPS.AP_APXVDMVD_PKG dependencies on AP_PRODUCT_SETUP

Line 134: --ap_product_setup for some of columns. For list of columns please refer to bug.

130: --
131: debug_info := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';
132: --Bug :2809214 MOAC - Supplier Attribute Change Project
133: --Changed the source table from financial_options and system_options to
134: --ap_product_setup for some of columns. For list of columns please refer to bug.
135:
136: --
137: -- Bug 5087698
138:

Line 292: ap_product_setup aps

288: gl_ledgers gl,
289: financials_system_params_all fin,
290: ap_system_parameters_all ap,
291: ap_awt_groups awt,
292: ap_product_setup aps
293: WHERE gl.ledger_id = fin.set_of_books_id
294: AND lc1.lookup_type(+) = 'PAYMENT METHOD'
295: AND lc1.lookup_code(+) = aps.payment_method_lookup_code
296: AND lc2.lookup_type(+) = 'PAY DATE BASIS'

Line 633: ap_product_setup aps

629: FROM ap_lookup_codes lc2,
630: ap_lookup_codes lc3,
631: po_lookup_codes pc3,
632: ap_terms tm,
633: ap_product_setup aps
634: WHERE lc2.lookup_type(+) = 'PAY DATE BASIS'
635: AND lc2.lookup_code(+) = aps.pay_date_basis_lookup_code
636: AND lc3.lookup_type(+) = 'TERMS DATE BASIS'
637: AND lc3.lookup_code(+) = aps.terms_date_basis