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 2317: from ar_lookups AL1

2313: FROM ar_trx_header_gt gt
2314: WHERE default_tax_exempt_flag IS NOT NULL
2315: AND NOT EXISTS (
2316: select 'X'
2317: from ar_lookups AL1
2318: where AL1.lookup_type = 'TAX_CONTROL_FLAG'
2319: and (AL1.lookup_code in ('R','S')
2320: or (AL1.lookup_code = 'E' and
2321: l_tax_use_exempt_flag = 'Y'))

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

2433: FROM ar_trx_header_gt gt
2434: WHERE gt.related_customer_trx_id IS NOT NULL
2435: AND NOT EXISTS (
2436: SELECT 'X'
2437: FROM ra_customer_trx trx, ra_batch_sources bs, ar_lookups look,
2438: ra_cust_trx_types types
2439: where trx.batch_source_id = bs.batch_source_id
2440: and trx.cust_trx_type_id = types.cust_trx_type_id
2441: and look.lookup_type = 'INV/CM'

Line 4255: from ar_lookups AL1

4251: FROM ar_trx_lines_gt
4252: WHERE tax_exempt_flag IS NOT NULL
4253: AND NOT EXISTS
4254: ( select 'X'
4255: from ar_lookups AL1
4256: where AL1.lookup_type = 'TAX_CONTROL_FLAG'
4257: and (AL1.lookup_code in ('R','S')
4258: or (AL1.lookup_code = 'E'
4259: and 'Y' = l_tax_use_exempt_flag))

Line 4298: FROM ar_lookups

4294: FROM ar_trx_lines_gt
4295: WHERE TAX_EXEMPT_REASON_CODE IS NOT null
4296: AND NOT EXISTS (
4297: SELECT 'X'
4298: FROM ar_lookups
4299: WHERE lookup_type = 'TAX_REASON'
4300: AND enabled_flag = 'Y'
4301: AND trx_date between start_date_active and nvl(end_date_active,trx_date)
4302: AND lookup_code = TAX_EXEMPT_REASON_CODE );

Line 4358: from ar_lookups

4354: FROM ar_trx_lines_gt gt
4355: WHERE gt.reason_code IS NOT NULL
4356: AND NOT EXISTS (
4357: select 'X'
4358: from ar_lookups
4359: where lookup_type = 'INVOICING_REASON'
4360: and enabled_flag = 'Y'
4361: and lookup_code = gt.reason_code
4362: and sysdate -- g_trx_date

Line 4758: ar_lookups

4754: WHERE gt.line_type = 'FREIGHT'
4755: AND gt.fob_point IS NOT NULL
4756: AND NOT EXISTS (
4757: SELECT 'X' FROM
4758: ar_lookups
4759: WHERE lookup_type = 'FOB'
4760: and lookup_code = gt.fob_point
4761: and gt.trx_date between start_date_active and nvl(end_date_active, gt.trx_date));
4762: