DBA Data[Home] [Help]

APPS.AR_PURGE dependencies on HZ_CUST_ACCOUNTS

Line 736: hz_cust_accounts cust,

732: hz_cust_acct_sites addr,
733: hz_party_sites party_site,
734: hz_locations loc,
735: hz_cust_site_uses su,
736: hz_cust_accounts cust,
737: hz_parties cust_party,
738: ar_receivable_applications ra,
739: ar_receivable_applications ra1, --bug1199027
740: ar_cash_receipt_history crh,

Line 1648: hz_cust_accounts cust_bill,

1644: ra_batch_sources bs,
1645: ra_batches batch,
1646: fnd_document_sequences doc,
1647: gl_sets_of_books sob,
1648: hz_cust_accounts cust_bill,
1649: hz_parties bill_party,
1650: hz_cust_site_uses su_bill,
1651: hz_cust_acct_sites addr_bill,
1652: hz_party_sites bill_ps,

Line 1654: hz_cust_accounts cust_ship,

1650: hz_cust_site_uses su_bill,
1651: hz_cust_acct_sites addr_bill,
1652: hz_party_sites bill_ps,
1653: hz_locations bill_loc,
1654: hz_cust_accounts cust_ship,
1655: hz_parties ship_party,
1656: hz_cust_site_uses su_ship,
1657: hz_cust_acct_sites addr_ship,
1658: hz_party_sites ship_ps,

Line 1828: hz_cust_accounts cust,

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
1831: WHERE lu.lookup_code (+) = adj.reason_code
1832: AND lu.lookup_type (+) = 'ADJUST_REASON'

Line 1981: hz_cust_accounts cust,

1977: hz_cust_acct_sites addr,
1978: hz_party_sites party_site,
1979: hz_locations loc,
1980: hz_cust_site_uses su,
1981: hz_cust_accounts cust,
1982: hz_parties cust_party,
1983: iby_trxn_extensions_v iby,
1984: ar_receivable_applications ra,
1985: ar_receivable_applications ra1, --bug1199027