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_AUTOSELECT_PKG dependencies on AP_LOOKUP_CODES

Line 145: l_nls_days ap_lookup_codes.displayed_field%TYPE;

141: l_inv_curr_int_amt NUMBER;
142: l_invoice_currency_code VARCHAR2(15);
143: l_invoice_exchange_rate NUMBER;
144: l_invoice_id number;
145: l_nls_days ap_lookup_codes.displayed_field%TYPE;
146: l_nls_int ap_lookup_codes.displayed_field%TYPE;
147: l_nls_interest ap_lookup_codes.displayed_field%TYPE;
148: l_nls_percent ap_lookup_codes.displayed_field%TYPE;
149: l_ok_to_pay_flag VARCHAR2(1);

Line 146: l_nls_int ap_lookup_codes.displayed_field%TYPE;

142: l_invoice_currency_code VARCHAR2(15);
143: l_invoice_exchange_rate NUMBER;
144: l_invoice_id number;
145: l_nls_days ap_lookup_codes.displayed_field%TYPE;
146: l_nls_int ap_lookup_codes.displayed_field%TYPE;
147: l_nls_interest ap_lookup_codes.displayed_field%TYPE;
148: l_nls_percent ap_lookup_codes.displayed_field%TYPE;
149: l_ok_to_pay_flag VARCHAR2(1);
150: l_org_id number;

Line 147: l_nls_interest ap_lookup_codes.displayed_field%TYPE;

143: l_invoice_exchange_rate NUMBER;
144: l_invoice_id number;
145: l_nls_days ap_lookup_codes.displayed_field%TYPE;
146: l_nls_int ap_lookup_codes.displayed_field%TYPE;
147: l_nls_interest ap_lookup_codes.displayed_field%TYPE;
148: l_nls_percent ap_lookup_codes.displayed_field%TYPE;
149: l_ok_to_pay_flag VARCHAR2(1);
150: l_org_id number;
151: l_pay_currency_code VARCHAR2(15);

Line 148: l_nls_percent ap_lookup_codes.displayed_field%TYPE;

144: l_invoice_id number;
145: l_nls_days ap_lookup_codes.displayed_field%TYPE;
146: l_nls_int ap_lookup_codes.displayed_field%TYPE;
147: l_nls_interest ap_lookup_codes.displayed_field%TYPE;
148: l_nls_percent ap_lookup_codes.displayed_field%TYPE;
149: l_ok_to_pay_flag VARCHAR2(1);
150: l_org_id number;
151: l_pay_currency_code VARCHAR2(15);
152: l_payment_amount NUMBER;

Line 186: FROM ap_lookup_codes l1,

182: INTO l_nls_interest,
183: l_nls_days,
184: l_nls_percent,
185: l_nls_int
186: FROM ap_lookup_codes l1,
187: ap_lookup_codes l2,
188: ap_lookup_codes l3,
189: ap_lookup_codes l4
190: WHERE l1.lookup_type = 'NLS TRANSLATION'

Line 187: ap_lookup_codes l2,

183: l_nls_days,
184: l_nls_percent,
185: l_nls_int
186: FROM ap_lookup_codes l1,
187: ap_lookup_codes l2,
188: ap_lookup_codes l3,
189: ap_lookup_codes l4
190: WHERE l1.lookup_type = 'NLS TRANSLATION'
191: AND l1.lookup_code = 'INTEREST'

Line 188: ap_lookup_codes l3,

184: l_nls_percent,
185: l_nls_int
186: FROM ap_lookup_codes l1,
187: ap_lookup_codes l2,
188: ap_lookup_codes l3,
189: ap_lookup_codes l4
190: WHERE l1.lookup_type = 'NLS TRANSLATION'
191: AND l1.lookup_code = 'INTEREST'
192: AND l2.lookup_type = 'NLS TRANSLATION'

Line 189: ap_lookup_codes l4

185: l_nls_int
186: FROM ap_lookup_codes l1,
187: ap_lookup_codes l2,
188: ap_lookup_codes l3,
189: ap_lookup_codes l4
190: WHERE l1.lookup_type = 'NLS TRANSLATION'
191: AND l1.lookup_code = 'INTEREST'
192: AND l2.lookup_type = 'NLS TRANSLATION'
193: AND l2.lookup_code = 'DAYS'

Line 4691: ap_lookup_codes rate,

4687: ap_batches_all ab,
4688: iby_payment_methods_vl iby,
4689: fnd_lookups vndr,
4690: hz_parties hz,
4691: ap_lookup_codes rate,
4692: ap_payment_templates apt
4693: where checkrun_id ='|| p_checkrun_id ||'
4694: and apt.template_id(+) = aisc.template_id
4695: and aisc.invoice_batch_id = ab.batch_id(+)