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.

[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on AP_LOOKUP_CODES

Line 339: l_nls_days ap_lookup_codes.displayed_field%TYPE;

335: l_inv_curr_int_amt NUMBER;
336: l_invoice_currency_code VARCHAR2(15);
337: l_invoice_exchange_rate NUMBER;
338: l_invoice_id number;
339: l_nls_days ap_lookup_codes.displayed_field%TYPE;
340: l_nls_int ap_lookup_codes.displayed_field%TYPE;
341: l_nls_interest ap_lookup_codes.displayed_field%TYPE;
342: l_nls_percent ap_lookup_codes.displayed_field%TYPE;
343: l_ok_to_pay_flag VARCHAR2(1);

Line 340: l_nls_int ap_lookup_codes.displayed_field%TYPE;

336: l_invoice_currency_code VARCHAR2(15);
337: l_invoice_exchange_rate NUMBER;
338: l_invoice_id number;
339: l_nls_days ap_lookup_codes.displayed_field%TYPE;
340: l_nls_int ap_lookup_codes.displayed_field%TYPE;
341: l_nls_interest ap_lookup_codes.displayed_field%TYPE;
342: l_nls_percent ap_lookup_codes.displayed_field%TYPE;
343: l_ok_to_pay_flag VARCHAR2(1);
344: l_org_id number;

Line 341: l_nls_interest ap_lookup_codes.displayed_field%TYPE;

337: l_invoice_exchange_rate NUMBER;
338: l_invoice_id number;
339: l_nls_days ap_lookup_codes.displayed_field%TYPE;
340: l_nls_int ap_lookup_codes.displayed_field%TYPE;
341: l_nls_interest ap_lookup_codes.displayed_field%TYPE;
342: l_nls_percent ap_lookup_codes.displayed_field%TYPE;
343: l_ok_to_pay_flag VARCHAR2(1);
344: l_org_id number;
345: l_pay_currency_code VARCHAR2(15);

Line 342: l_nls_percent ap_lookup_codes.displayed_field%TYPE;

338: l_invoice_id number;
339: l_nls_days ap_lookup_codes.displayed_field%TYPE;
340: l_nls_int ap_lookup_codes.displayed_field%TYPE;
341: l_nls_interest ap_lookup_codes.displayed_field%TYPE;
342: l_nls_percent ap_lookup_codes.displayed_field%TYPE;
343: l_ok_to_pay_flag VARCHAR2(1);
344: l_org_id number;
345: l_pay_currency_code VARCHAR2(15);
346: l_payment_amount NUMBER;

Line 380: FROM ap_lookup_codes l1,

376: INTO l_nls_interest,
377: l_nls_days,
378: l_nls_percent,
379: l_nls_int
380: FROM ap_lookup_codes l1,
381: ap_lookup_codes l2,
382: ap_lookup_codes l3,
383: ap_lookup_codes l4
384: WHERE l1.lookup_type = 'NLS TRANSLATION'

Line 381: ap_lookup_codes l2,

377: l_nls_days,
378: l_nls_percent,
379: l_nls_int
380: FROM ap_lookup_codes l1,
381: ap_lookup_codes l2,
382: ap_lookup_codes l3,
383: ap_lookup_codes l4
384: WHERE l1.lookup_type = 'NLS TRANSLATION'
385: AND l1.lookup_code = 'INTEREST'

Line 382: ap_lookup_codes l3,

378: l_nls_percent,
379: l_nls_int
380: FROM ap_lookup_codes l1,
381: ap_lookup_codes l2,
382: ap_lookup_codes l3,
383: ap_lookup_codes l4
384: WHERE l1.lookup_type = 'NLS TRANSLATION'
385: AND l1.lookup_code = 'INTEREST'
386: AND l2.lookup_type = 'NLS TRANSLATION'

Line 383: ap_lookup_codes l4

379: l_nls_int
380: FROM ap_lookup_codes l1,
381: ap_lookup_codes l2,
382: ap_lookup_codes l3,
383: ap_lookup_codes l4
384: WHERE l1.lookup_type = 'NLS TRANSLATION'
385: AND l1.lookup_code = 'INTEREST'
386: AND l2.lookup_type = 'NLS TRANSLATION'
387: AND l2.lookup_code = 'DAYS'

Line 6291: ap_lookup_codes rate,

6287: ap_batches_all ab,
6288: iby_payment_methods_vl iby,
6289: fnd_lookups vndr,
6290: hz_parties hz,
6291: ap_lookup_codes rate,
6292: ap_payment_templates apt
6293: where checkrun_id ='|| p_checkrun_id ||'
6294: and apt.template_id(+) = aisc.template_id
6295: and aisc.invoice_batch_id = ab.batch_id(+)