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 129: debug_info := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';

125: dummy := fnd_installation.get_app_info('PO',l_po_status,l_industry,l_oracle_schema);
126: x_PO_inst_flag := l_po_status;
127: --
128: --
129: debug_info := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';
130: --Bug :2809214 MOAC - Supplier Attribute Change Project
131: --Changed the source table from financial_options and system_options to
132: --ap_product_setup for some of columns. For list of columns please refer to bug.
133:

Line 274: FROM ap_lookup_codes lc1,

270: x_default_awt_group_name,
271: x_allow_awt_flag,
272: x_use_bank_charge_flag,
273: x_bank_charge_bearer
274: FROM ap_lookup_codes lc1,
275: ap_lookup_codes lc2,
276: ap_lookup_codes lc3,
277: po_lookup_codes pc1,
278: po_lookup_codes pc2,

Line 275: ap_lookup_codes lc2,

271: x_allow_awt_flag,
272: x_use_bank_charge_flag,
273: x_bank_charge_bearer
274: FROM ap_lookup_codes lc1,
275: ap_lookup_codes lc2,
276: ap_lookup_codes lc3,
277: po_lookup_codes pc1,
278: po_lookup_codes pc2,
279: po_lookup_codes pc3,

Line 276: ap_lookup_codes lc3,

272: x_use_bank_charge_flag,
273: x_bank_charge_bearer
274: FROM ap_lookup_codes lc1,
275: ap_lookup_codes lc2,
276: ap_lookup_codes lc3,
277: po_lookup_codes pc1,
278: po_lookup_codes pc2,
279: po_lookup_codes pc3,
280: hr_locations_all hl1,

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

454: x_ship_via_lookup_code := null;
455: x_ship_via_disp := null;
456: end if;
457: --
458: -- Supply defaults from ap_lookup_codes where null values resulted
459: -- from lookup in financials_system_parameters table
460: --
461: if x_pay_date_basis_lookup_code is NULL then
462: debug_info := 'Select pay_date_basis displayed field';

Line 467: FROM ap_lookup_codes lc

463: SELECT lc.lookup_code,
464: lc.displayed_field
465: INTO x_pay_date_basis_lookup_code,
466: x_pay_date_basis_disp
467: FROM ap_lookup_codes lc
468: WHERE lc.lookup_type = 'PAY DATE BASIS'
469: AND lc.lookup_code = 'DISCOUNT';
470: end if;
471:

Line 479: FROM ap_lookup_codes lc

475: lc.displayed_field
476: INTO x_payment_method_lookup_code,
477: x_payment_method_disp
478:
479: FROM ap_lookup_codes lc
480: WHERE lc.lookup_type = 'PAYMENT METHOD'
481: AND lc.lookup_code = 'CHECK';
482: end if;
483: --

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

565:
566: --
567: --
568: debug_info
569: := 'Select from ap_lookup_codes, po_lookup_codes, hr_locations, ....';
570: SELECT aps.supplier_numbering_method,
571: aps.supplier_num_type,
572: aps.terms_id, -- terms_id
573: tm.name, -- terms_name

Line 608: FROM ap_lookup_codes lc2,

604: x_sysdate,
605: -- x_use_bank_charge_flag,
606: -- x_bank_charge_bearer
607: x_fin_match_option --bug6075649
608: FROM ap_lookup_codes lc2,
609: ap_lookup_codes lc3,
610: po_lookup_codes pc3,
611: ap_terms tm,
612: ap_product_setup aps

Line 609: ap_lookup_codes lc3,

605: -- x_use_bank_charge_flag,
606: -- x_bank_charge_bearer
607: x_fin_match_option --bug6075649
608: FROM ap_lookup_codes lc2,
609: ap_lookup_codes lc3,
610: po_lookup_codes pc3,
611: ap_terms tm,
612: ap_product_setup aps
613: WHERE lc2.lookup_type(+) = 'PAY DATE BASIS'

Line 637: FROM ap_lookup_codes lc

633: SELECT lc.lookup_code,
634: lc.displayed_field
635: INTO x_pay_date_basis_lookup_code,
636: x_pay_date_basis_disp
637: FROM ap_lookup_codes lc
638: WHERE lc.lookup_type = 'PAY DATE BASIS'
639: AND lc.lookup_code = 'DISCOUNT';
640: end if;
641: