APPS.AR_INVOICE_UTILS dependencies on AR_LOOKUPS

Line 202: FROM ar_lookups

198: FROM ar_trx_header_gt gt
199: WHERE gt.fob_point IS NOT NULL
200: AND NOT EXISTS
201: (SELECT 'X'
202: FROM ar_lookups
203: WHERE lookup_code = gt.fob_point
204: AND lookup_type = 'FOB'
205: AND gt.trx_date
206: BETWEEN start_date_active and nvl(end_date_active, gt.trx_date));

Line 2394: from ar_lookups AL1

2390: FROM ar_trx_header_gt gt
2391: WHERE default_tax_exempt_flag IS NOT NULL
2392: AND NOT EXISTS (
2393: select 'X'
2394: from ar_lookups AL1
2395: where AL1.lookup_type = 'TAX_CONTROL_FLAG'
2396: and (AL1.lookup_code in ('R','S')
2397: or (AL1.lookup_code = 'E' and
2398: l_tax_use_exempt_flag = 'Y'))

Line 2514: FROM ra_customer_trx trx, ra_batch_sources bs, ar_lookups look,

2510: FROM ar_trx_header_gt gt
2511: WHERE gt.related_customer_trx_id IS NOT NULL
2512: AND NOT EXISTS (
2513: SELECT 'X'
2514: FROM ra_customer_trx trx, ra_batch_sources bs, ar_lookups look,
2515: ra_cust_trx_types types
2516: where trx.batch_source_id = bs.batch_source_id
2517: and trx.cust_trx_type_id = types.cust_trx_type_id
2518: and look.lookup_type = 'INV/CM'

Line 4361: from ar_lookups AL1

4357: FROM ar_trx_lines_gt
4358: WHERE tax_exempt_flag IS NOT NULL
4359: AND NOT EXISTS
4360: ( select 'X'
4361: from ar_lookups AL1
4362: where AL1.lookup_type = 'TAX_CONTROL_FLAG'
4363: and (AL1.lookup_code in ('R','S')
4364: or (AL1.lookup_code = 'E'
4365: and 'Y' = l_tax_use_exempt_flag))

Line 4404: FROM ar_lookups

4400: FROM ar_trx_lines_gt
4401: WHERE TAX_EXEMPT_REASON_CODE IS NOT null
4402: AND NOT EXISTS (
4403: SELECT 'X'
4404: FROM ar_lookups
4405: WHERE lookup_type = 'TAX_REASON'
4406: AND enabled_flag = 'Y'
4407: AND trx_date between start_date_active and nvl(end_date_active,trx_date)
4408: AND lookup_code = TAX_EXEMPT_REASON_CODE );

Line 4464: from ar_lookups

4460: FROM ar_trx_lines_gt gt
4461: WHERE gt.reason_code IS NOT NULL
4462: AND NOT EXISTS (
4463: select 'X'
4464: from ar_lookups
4465: where lookup_type = 'INVOICING_REASON'
4466: and enabled_flag = 'Y'
4467: and lookup_code = gt.reason_code
4468: and sysdate -- g_trx_date

Line 4864: ar_lookups

4860: WHERE gt.line_type = 'FREIGHT'
4861: AND gt.fob_point IS NOT NULL
4862: AND NOT EXISTS (
4863: SELECT 'X' FROM
4864: ar_lookups
4865: WHERE lookup_type = 'FOB'
4866: and lookup_code = gt.fob_point
4867: and gt.trx_date between start_date_active and nvl(end_date_active, gt.trx_date));
4868: