DBA Data[Home] [Help]

APPS.ARP_TRX_DEFAULTS_2 dependencies on AR_LOOKUPS

Line 242: ar_lookups.lookup_code%type,

238: ra_cust_trx_types.natural_application_only_flag%type,
239: p_default_tax_calculation_flag OUT NOCOPY
240: ra_cust_trx_types.tax_calculation_flag%type,
241: p_default_status_code OUT NOCOPY
242: ar_lookups.lookup_code%type,
243: p_default_status OUT NOCOPY
244: ar_lookups.meaning%type,
245: p_default_printing_option_code OUT NOCOPY
246: ar_lookups.lookup_code%type,

Line 244: ar_lookups.meaning%type,

240: ra_cust_trx_types.tax_calculation_flag%type,
241: p_default_status_code OUT NOCOPY
242: ar_lookups.lookup_code%type,
243: p_default_status OUT NOCOPY
244: ar_lookups.meaning%type,
245: p_default_printing_option_code OUT NOCOPY
246: ar_lookups.lookup_code%type,
247: p_default_printing_option OUT NOCOPY
248: ar_lookups.meaning%type,

Line 246: ar_lookups.lookup_code%type,

242: ar_lookups.lookup_code%type,
243: p_default_status OUT NOCOPY
244: ar_lookups.meaning%type,
245: p_default_printing_option_code OUT NOCOPY
246: ar_lookups.lookup_code%type,
247: p_default_printing_option OUT NOCOPY
248: ar_lookups.meaning%type,
249: p_default_term_id OUT NOCOPY
250: ra_terms.term_id%type,

Line 248: ar_lookups.meaning%type,

244: ar_lookups.meaning%type,
245: p_default_printing_option_code OUT NOCOPY
246: ar_lookups.lookup_code%type,
247: p_default_printing_option OUT NOCOPY
248: ar_lookups.meaning%type,
249: p_default_term_id OUT NOCOPY
250: ra_terms.term_id%type,
251: p_default_term_name OUT NOCOPY
252: ra_terms.name%type,

Line 313: FROM ar_lookups arl_print,

309: p_default_printing_option_code,
310: p_default_printing_option,
311: l_default_term_id,
312: p_default_term_name
313: FROM ar_lookups arl_print,
314: ar_lookups arl_status,
315: ra_terms rat,
316: ra_cust_trx_types ctt
317: WHERE ctt.cust_trx_type_id = p_cust_trx_type_id

Line 314: ar_lookups arl_status,

310: p_default_printing_option,
311: l_default_term_id,
312: p_default_term_name
313: FROM ar_lookups arl_print,
314: ar_lookups arl_status,
315: ra_terms rat,
316: ra_cust_trx_types ctt
317: WHERE ctt.cust_trx_type_id = p_cust_trx_type_id
318: AND 'INVOICE_PRINT_OPTIONS' = arl_print.lookup_type(+)