eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_APXVDMVD_PKG dependencies on AP_LOOKUP_CODES

Line 131: debug_info := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';

127: dummy := fnd_installation.get_app_info('PO',l_po_status,l_industry,l_oracle_schema);
128: x_PO_inst_flag := l_po_status;
129: --
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:

Line 278: FROM ap_lookup_codes lc1,

274: x_allow_awt_flag,
275: x_create_awt_dists_type, --bug 13092500
276: x_use_bank_charge_flag,
277: x_bank_charge_bearer
278: FROM ap_lookup_codes lc1,
279: ap_lookup_codes lc2,
280: ap_lookup_codes lc3,
281: po_lookup_codes pc1,
282: po_lookup_codes pc2,

Line 279: ap_lookup_codes lc2,

275: x_create_awt_dists_type, --bug 13092500
276: x_use_bank_charge_flag,
277: x_bank_charge_bearer
278: FROM ap_lookup_codes lc1,
279: ap_lookup_codes lc2,
280: ap_lookup_codes lc3,
281: po_lookup_codes pc1,
282: po_lookup_codes pc2,
283: po_lookup_codes pc3,

Line 280: ap_lookup_codes lc3,

276: x_use_bank_charge_flag,
277: x_bank_charge_bearer
278: FROM ap_lookup_codes lc1,
279: ap_lookup_codes lc2,
280: ap_lookup_codes lc3,
281: po_lookup_codes pc1,
282: po_lookup_codes pc2,
283: po_lookup_codes pc3,
284: hr_locations_all hl1,

Line 479: -- Supply defaults from ap_lookup_codes where null values resulted

475: x_ship_via_lookup_code := null;
476: x_ship_via_disp := null;
477: end if;
478: --
479: -- Supply defaults from ap_lookup_codes where null values resulted
480: -- from lookup in financials_system_parameters table
481: --
482: if x_pay_date_basis_lookup_code is NULL then
483: debug_info := 'Select pay_date_basis displayed field';

Line 488: FROM ap_lookup_codes lc

484: SELECT lc.lookup_code,
485: lc.displayed_field
486: INTO x_pay_date_basis_lookup_code,
487: x_pay_date_basis_disp
488: FROM ap_lookup_codes lc
489: WHERE lc.lookup_type = 'PAY DATE BASIS'
490: AND lc.lookup_code = 'DISCOUNT';
491: end if;
492:

Line 500: FROM ap_lookup_codes lc

496: lc.displayed_field
497: INTO x_payment_method_lookup_code,
498: x_payment_method_disp
499:
500: FROM ap_lookup_codes lc
501: WHERE lc.lookup_type = 'PAYMENT METHOD'
502: AND lc.lookup_code = 'CHECK';
503: end if;
504: --

Line 590: := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';

586:
587: --
588: --
589: debug_info
590: := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';
591: SELECT aps.supplier_numbering_method,
592: aps.supplier_num_type,
593: aps.terms_id, -- terms_id
594: tm.name, -- terms_name

Line 629: FROM ap_lookup_codes lc2,

625: x_sysdate,
626: -- x_use_bank_charge_flag,
627: -- x_bank_charge_bearer
628: x_fin_match_option --bug6075649
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

Line 630: ap_lookup_codes lc3,

626: -- x_use_bank_charge_flag,
627: -- x_bank_charge_bearer
628: x_fin_match_option --bug6075649
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'

Line 659: FROM ap_lookup_codes lc

655: SELECT lc.lookup_code,
656: lc.displayed_field
657: INTO x_pay_date_basis_lookup_code,
658: x_pay_date_basis_disp
659: FROM ap_lookup_codes lc
660: WHERE lc.lookup_type = 'PAY DATE BASIS'
661: AND lc.lookup_code = 'DISCOUNT';
662: end if;
663: