DBA Data[Home] [Help]

APPS.AR_PURGE dependencies on AR_LOOKUPS

Line 723: FROM ar_lookups lu,

719: '' reference_type, /* reference_type */
720: to_number('') reference_id, /* reference_id */
721: '' cust_rcpt_reference, /* customer_receipt_reference */
722: '' bank_acct_name2 /* bank_account_name */
723: FROM ar_lookups lu,
724: ra_rules rule,
725: ra_cust_trx_types ctt_prev,
726: ra_cust_trx_types ctt,
727: ra_batch_sources bs,

Line 909: ar_lookups lu,

905: '' bank_acct_name2 /* bank_account_name */
906: FROM ra_cust_trx_types ctt,
907: fnd_document_sequences doc,
908: gl_sets_of_books sob,
909: ar_lookups lu,
910: ar_adjustments adj,
911: hz_cust_accounts cust,
912: hz_parties cust_party,
913: ra_customer_trx ct

Line 1049: FROM ar_lookups lu1,

1045: cr.reference_type reference_type,
1046: cr.reference_id reference_id,
1047: cr.customer_receipt_reference cust_rcpt_reference,
1048: cba.bank_account_name bank_acct_name2
1049: FROM ar_lookups lu1,
1050: ar_lookups lu2,
1051: ar_receipt_methods rm,
1052: ar_batch_sources bs,
1053: ar_batches batch,

Line 1050: ar_lookups lu2,

1046: cr.reference_id reference_id,
1047: cr.customer_receipt_reference cust_rcpt_reference,
1048: cba.bank_account_name bank_acct_name2
1049: FROM ar_lookups lu1,
1050: ar_lookups lu2,
1051: ar_receipt_methods rm,
1052: ar_batch_sources bs,
1053: ar_batches batch,
1054: ar_batches batch_remit,

Line 1646: ar_lookups lu_te,

1642: to_date(null) expiration_date, /* expiration_date */
1643: to_number('') expiration_days, /* expiration_days */
1644: ctl.override_auto_accounting_flag /* override_auto_accounting_flag */
1645: FROM
1646: ar_lookups lu_te,
1647: ra_tax_exemptions te,
1648: ar_lookups lu_ier,
1649: ra_item_exception_rates ier,
1650: ar_sales_tax st,

Line 1648: ar_lookups lu_ier,

1644: ctl.override_auto_accounting_flag /* override_auto_accounting_flag */
1645: FROM
1646: ar_lookups lu_te,
1647: ra_tax_exemptions te,
1648: ar_lookups lu_ier,
1649: ra_item_exception_rates ier,
1650: ar_sales_tax st,
1651: ar_vat_tax vt,
1652: ar_lookups lu_line,

Line 1652: ar_lookups lu_line,

1648: ar_lookups lu_ier,
1649: ra_item_exception_rates ier,
1650: ar_sales_tax st,
1651: ar_vat_tax vt,
1652: ar_lookups lu_line,
1653: ar_lookups lu_line2,
1654: ra_rules rule1,
1655: ra_cust_trx_types ctt_prev,
1656: ra_cust_trx_types ctt,

Line 1653: ar_lookups lu_line2,

1649: ra_item_exception_rates ier,
1650: ar_sales_tax st,
1651: ar_vat_tax vt,
1652: ar_lookups lu_line,
1653: ar_lookups lu_line2,
1654: ra_rules rule1,
1655: ra_cust_trx_types ctt_prev,
1656: ra_cust_trx_types ctt,
1657: mtl_system_items mtl,