DBA Data[Home] [Help]

APPS.ARP_TRX_DEFAULTS dependencies on AR_LOOKUPS

Line 167: ar_lookups.lookup_code%type,

163: ra_cust_trx_types.natural_application_only_flag%type,
164: p_tax_calculation_flag OUT NOCOPY
165: ra_cust_trx_types.tax_calculation_flag%type,
166: p_default_status_code OUT NOCOPY
167: ar_lookups.lookup_code%type,
168: p_default_status OUT NOCOPY
169: ar_lookups.meaning%type,
170: p_default_printing_option_code OUT NOCOPY
171: ar_lookups.lookup_code%type,

Line 169: ar_lookups.meaning%type,

165: ra_cust_trx_types.tax_calculation_flag%type,
166: p_default_status_code OUT NOCOPY
167: ar_lookups.lookup_code%type,
168: p_default_status OUT NOCOPY
169: ar_lookups.meaning%type,
170: p_default_printing_option_code OUT NOCOPY
171: ar_lookups.lookup_code%type,
172: p_default_printing_option OUT NOCOPY
173: ar_lookups.meaning%type,

Line 171: ar_lookups.lookup_code%type,

167: ar_lookups.lookup_code%type,
168: p_default_status OUT NOCOPY
169: ar_lookups.meaning%type,
170: p_default_printing_option_code OUT NOCOPY
171: ar_lookups.lookup_code%type,
172: p_default_printing_option OUT NOCOPY
173: ar_lookups.meaning%type,
174: p_default_term_id OUT NOCOPY
175: ra_terms.term_id%type,

Line 173: ar_lookups.meaning%type,

169: ar_lookups.meaning%type,
170: p_default_printing_option_code OUT NOCOPY
171: ar_lookups.lookup_code%type,
172: p_default_printing_option OUT NOCOPY
173: ar_lookups.meaning%type,
174: p_default_term_id OUT NOCOPY
175: ra_terms.term_id%type,
176: p_default_term_name OUT NOCOPY
177: ra_terms.name%type,

Line 200: l_default_status_code ar_lookups.lookup_code%type;

196: l_batch_source_type ra_batch_sources.batch_source_type%type;
197: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
198: l_bs_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
199: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
200: l_default_status_code ar_lookups.lookup_code%type;
201: l_default_printing_option_code ar_lookups.lookup_code%type;
202: l_default_term_id ra_terms.term_id%type;
203: l_default_term_name ra_terms.name%type;
204: l_default_class ra_cust_trx_types.type%type;

Line 201: l_default_printing_option_code ar_lookups.lookup_code%type;

197: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
198: l_bs_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
199: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
200: l_default_status_code ar_lookups.lookup_code%type;
201: l_default_printing_option_code ar_lookups.lookup_code%type;
202: l_default_term_id ra_terms.term_id%type;
203: l_default_term_name ra_terms.name%type;
204: l_default_class ra_cust_trx_types.type%type;
205: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;

Line 477: FROM ar_lookups arl_status

473: SELECT lookup_code,
474: meaning
475: INTO p_default_status_code,
476: p_default_status
477: FROM ar_lookups arl_status
478: WHERE 'INVOICE_TRX_STATUS' = arl_status.lookup_type
479: AND 'OP' = arl_status.lookup_code
480: AND 'Y' = arl_status.enabled_flag
481: AND NVL(p_trx_date, TRUNC(SYSDATE))

Line 508: FROM ar_lookups arl_print

504: SELECT lookup_code,
505: meaning
506: INTO p_default_printing_option_code,
507: p_default_printing_option
508: FROM ar_lookups arl_print
509: WHERE 'INVOICE_PRINT_OPTIONS' = arl_print.lookup_type
510: AND 'PRI' = arl_print.lookup_code
511: AND 'Y' = arl_print.enabled_flag
512: AND NVL(p_trx_date, TRUNC(SYSDATE))