APPS.IEX_COLL_IND dependencies on AR_TRX_BAL_SUMMARY

Line 1834: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a, hz_cust_accounts d

1830: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
1831: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1832: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
1833: INTO l_tot_rec
1834: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a, hz_cust_accounts d
1835: where b.set_of_books_id = a.set_of_books_id
1836: AND c.cust_account_id = d.cust_account_id
1837: AND d.party_id = p_party_id
1838: and c.org_id = b.org_id;

Line 1880: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a

1876: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
1877: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1878: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
1879: INTO l_tot_rec
1880: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a
1881: where b.set_of_books_id = a.set_of_books_id
1882: AND c.cust_account_id = p_cust_account_id
1883: and c.org_id = b.org_id;
1884:

Line 1923: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a

1919: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
1920: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1921: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
1922: INTO l_tot_rec
1923: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a
1924: where b.set_of_books_id = a.set_of_books_id
1925: AND c.site_use_id = p_customer_site_use_id
1926: and c.org_id = b.org_id;
1927:

Line 2230: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a,hz_cust_accounts d

2226: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
2227: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2228: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
2229: INTO l_op_bal
2230: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a,hz_cust_accounts d
2231: where c.cust_account_id = d.cust_account_id
2232: AND d.party_id = p_party_id
2233: AND b.set_of_books_id = a.set_of_books_id
2234: and c.org_id = b.org_id;

Line 2249: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a

2245: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
2246: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2247: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
2248: INTO l_op_bal
2249: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a
2250: where c.cust_account_id= p_cust_account_id
2251: AND b.set_of_books_id = a.set_of_books_id
2252: and c.org_id = b.org_id;
2253: ELSE IF p_customer_site_use_id IS NOT NULL THEN

Line 2267: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a

2263: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
2264: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2265: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
2266: INTO l_op_bal
2267: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a
2268: where c.site_use_id = p_customer_site_use_id
2269: AND b.set_of_books_id = a.set_of_books_id
2270: and c.org_id = b.org_id;
2271: END IF;