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.AR_PURGE dependencies on AR_LOOKUPS

Line 722: FROM ar_lookups lu1,

718: cr.reference_type reference_type,
719: cr.reference_id reference_id,
720: cr.customer_receipt_reference cust_rcpt_reference,
721: ba2.bank_account_name bank_acct_name2
722: FROM ar_lookups lu1,
723: ar_lookups lu2,
724: ap_bank_accounts ba2,
725: ap_bank_accounts ba,
726: ar_receipt_methods rm,

Line 723: ar_lookups lu2,

719: cr.reference_id reference_id,
720: cr.customer_receipt_reference cust_rcpt_reference,
721: ba2.bank_account_name bank_acct_name2
722: FROM ar_lookups lu1,
723: ar_lookups lu2,
724: ap_bank_accounts ba2,
725: ap_bank_accounts ba,
726: ar_receipt_methods rm,
727: ar_batch_sources bs,

Line 1640: FROM ar_lookups lu,

1636: '' reference_type, /* reference_type */
1637: to_number('') reference_id, /* reference_id */
1638: '' cust_rcpt_reference, /* customer_receipt_reference */
1639: '' bank_acct_name2 /* bank_account_name */
1640: FROM ar_lookups lu,
1641: ra_rules rule,
1642: ra_cust_trx_types ctt_prev,
1643: ra_cust_trx_types ctt,
1644: ra_batch_sources bs,

Line 1826: ar_lookups lu,

1822: '' bank_acct_name2 /* bank_account_name */
1823: FROM ra_cust_trx_types ctt,
1824: fnd_document_sequences doc,
1825: gl_sets_of_books sob,
1826: ar_lookups lu,
1827: ar_adjustments adj,
1828: hz_cust_accounts cust,
1829: hz_parties cust_party,
1830: ra_customer_trx ct

Line 1966: FROM ar_lookups lu1,

1962: cr.reference_type reference_type,
1963: cr.reference_id reference_id,
1964: cr.customer_receipt_reference cust_rcpt_reference,
1965: cba.bank_account_name bank_acct_name2
1966: FROM ar_lookups lu1,
1967: ar_lookups lu2,
1968: ar_receipt_methods rm,
1969: ar_batch_sources bs,
1970: ar_batches batch,

Line 1967: ar_lookups lu2,

1963: cr.reference_id reference_id,
1964: cr.customer_receipt_reference cust_rcpt_reference,
1965: cba.bank_account_name bank_acct_name2
1966: FROM ar_lookups lu1,
1967: ar_lookups lu2,
1968: ar_receipt_methods rm,
1969: ar_batch_sources bs,
1970: ar_batches batch,
1971: ar_batches batch_remit,

Line 2563: ar_lookups lu_te,

2559: to_date(null) expiration_date, /* expiration_date */
2560: to_number('') expiration_days, /* expiration_days */
2561: ctl.override_auto_accounting_flag /* override_auto_accounting_flag */
2562: FROM
2563: ar_lookups lu_te,
2564: ra_tax_exemptions te,
2565: ar_lookups lu_ier,
2566: ra_item_exception_rates ier,
2567: ar_sales_tax st,

Line 2565: ar_lookups lu_ier,

2561: ctl.override_auto_accounting_flag /* override_auto_accounting_flag */
2562: FROM
2563: ar_lookups lu_te,
2564: ra_tax_exemptions te,
2565: ar_lookups lu_ier,
2566: ra_item_exception_rates ier,
2567: ar_sales_tax st,
2568: ar_vat_tax vt,
2569: ar_lookups lu_line,

Line 2569: ar_lookups lu_line,

2565: ar_lookups lu_ier,
2566: ra_item_exception_rates ier,
2567: ar_sales_tax st,
2568: ar_vat_tax vt,
2569: ar_lookups lu_line,
2570: ar_lookups lu_line2,
2571: ra_rules rule1,
2572: ra_cust_trx_types ctt_prev,
2573: ra_cust_trx_types ctt,

Line 2570: ar_lookups lu_line2,

2566: ra_item_exception_rates ier,
2567: ar_sales_tax st,
2568: ar_vat_tax vt,
2569: ar_lookups lu_line,
2570: ar_lookups lu_line2,
2571: ra_rules rule1,
2572: ra_cust_trx_types ctt_prev,
2573: ra_cust_trx_types ctt,
2574: mtl_system_items mtl,