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.IEX_COLL_IND dependencies on AR_SYSTEM_PARAMETERS

Line 713: FROM ar_system_parameters sp,

709: 0) )
710: )
711: ), 0) /* DSO */
712: INTO l_conv_dso
713: FROM ar_system_parameters sp,
714: hz_cust_accounts cust_acct,
715: ar_payment_schedules ps
716: WHERE ps.customer_id = cust_acct.cust_account_id
717: AND cust_acct.party_id = p_party_id

Line 756: FROM ar_system_parameters sp,

752: 0) )
753: )
754: ), 0) /* DSO */
755: INTO l_conv_dso
756: FROM ar_system_parameters sp,
757: ar_payment_schedules ps
758: WHERE ps.customer_id = p_cust_account_id
759: -- Begin fix bug #5261855-jypark-06/16/2006-add addtional condition for performance
760: AND ps.status = 'OP'

Line 798: FROM ar_system_parameters sp,

794: 0) )
795: )
796: ), 0) /* DSO */
797: INTO l_conv_dso
798: FROM ar_system_parameters sp,
799: ar_payment_schedules ps
800: WHERE ps.customer_site_use_id = p_customer_site_use_id
801: -- Begin fix bug #5261855-jypark-06/16/2006-add addtional condition for performance
802: AND ps.status = 'OP'

Line 1556: FROM ar_trx_summary trx_summ,ar_system_parameters asp,--Added for Bug 9404646 09-Mar-2010 barathsr

1552: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1553: -- sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1554: sysdate, l_conversion_type , trx_summ.op_bal_high_watermark))
1555: INTO l_high_credit_ytd
1556: FROM ar_trx_summary trx_summ,ar_system_parameters asp,--Added for Bug 9404646 09-Mar-2010 barathsr
1557: -- ar_cmgt_setup_options cm_opt,
1558: hz_cust_accounts ca
1559: WHERE trx_summ.org_id=asp.org_id--Added for Bug 9404646 09-Mar-2010 barathsr
1560: AND trx_summ.cust_account_id = ca.cust_account_id

Line 1567: FROM ar_trx_summary trx_summ,ar_system_parameters asp--Added for Bug 9404646 09-Mar-2010 barathsr

1563: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1564: -- sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1565: sysdate, l_conversion_type , trx_summ.op_bal_high_watermark))
1566: INTO l_high_credit_ytd
1567: FROM ar_trx_summary trx_summ,ar_system_parameters asp--Added for Bug 9404646 09-Mar-2010 barathsr
1568: -- ar_cmgt_setup_options cm_opt
1569: WHERE trx_summ.org_id=asp.org_id--Added for Bug 9404646 09-Mar-2010 barathsr
1570: AND trx_summ.cust_account_id = p_cust_account_id;
1571: ELSIF p_customer_site_use_id IS NOT NULL THEN

Line 1576: FROM ar_trx_summary trx_summ,ar_system_parameters asp--Added for Bug 9404646 09-Mar-2010 barathsr

1572: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1573: -- sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1574: sysdate, l_conversion_type , trx_summ.op_bal_high_watermark))
1575: INTO l_high_credit_ytd
1576: FROM ar_trx_summary trx_summ,ar_system_parameters asp--Added for Bug 9404646 09-Mar-2010 barathsr
1577: -- ar_cmgt_setup_options cm_opt
1578: WHERE trx_summ.org_id=asp.org_id--Added for Bug 9404646 09-Mar-2010 barathsr
1579: AND trx_summ.site_use_id = p_customer_site_use_id;
1580: END IF;

Line 1613: ar_system_parameters b,

1609: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1610: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0))
1611: INTO l_amount_due_org
1612: from gl_sets_of_books a,
1613: ar_system_parameters b,
1614: ar_trx_summary c,
1615: hz_cust_accounts d
1616: where a.set_of_books_id = b.set_of_books_id
1617: and b.org_id = c.org_id

Line 1632: ar_system_parameters b,

1628: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1629: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0))
1630: INTO l_amount_due_org
1631: from gl_sets_of_books a,
1632: ar_system_parameters b,
1633: ar_trx_summary c
1634: where a.set_of_books_id = b.set_of_books_id
1635: and b.org_id = c.org_id
1636: and c.cust_account_id = p_cust_account_id

Line 1649: ar_system_parameters b,

1645: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1646: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0))
1647: INTO l_amount_due_org
1648: from gl_sets_of_books a,
1649: ar_system_parameters b,
1650: ar_trx_summary c
1651: where a.set_of_books_id = b.set_of_books_id
1652: and b.org_id = c.org_id
1653: AND c.site_use_id = p_customer_site_use_id

Line 1680: ar_system_parameters b,

1676: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1677: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
1678: INTO l_adj_total
1679: from gl_sets_of_books a,
1680: ar_system_parameters b,
1681: ar_trx_summary c,
1682: hz_cust_accounts d
1683: where a.set_of_books_id = b.set_of_books_id
1684: and b.org_id = c.org_id

Line 1693: ar_system_parameters b,

1689: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1690: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
1691: INTO l_adj_total
1692: from gl_sets_of_books a,
1693: ar_system_parameters b,
1694: ar_trx_summary c
1695: where a.set_of_books_id = b.set_of_books_id
1696: and b.org_id = c.org_id
1697: and c.cust_account_id = p_cust_account_id

Line 1704: ar_system_parameters b,

1700: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1701: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
1702: INTO l_adj_total
1703: from gl_sets_of_books a,
1704: ar_system_parameters b,
1705: ar_trx_summary c
1706: where a.set_of_books_id = b.set_of_books_id
1707: and b.org_id = c.org_id
1708: AND c.site_use_id = p_customer_site_use_id

Line 1746: ar_system_parameters b,

1742: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1743: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_credit_memos_value),0))
1744: INTO l_amount_due_rem
1745: from gl_sets_of_books a,
1746: ar_system_parameters b,
1747: ar_trx_summary c,
1748: hz_cust_accounts d
1749: where a.set_of_books_id = b.set_of_books_id
1750: and b.org_id = c.org_id

Line 1771: ar_system_parameters b,

1767: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1768: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_credit_memos_value),0))
1769: INTO l_amount_due_rem
1770: from gl_sets_of_books a,
1771: ar_system_parameters b,
1772: ar_trx_summary c
1773: where a.set_of_books_id = b.set_of_books_id
1774: and b.org_id = c.org_id
1775: and c.cust_account_id = p_cust_account_id

Line 1794: ar_system_parameters b,

1790: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1791: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_credit_memos_value),0))
1792: INTO l_amount_due_rem
1793: from gl_sets_of_books a,
1794: ar_system_parameters b,
1795: ar_trx_summary c
1796: where a.set_of_books_id = b.set_of_books_id
1797: and b.org_id = c.org_id
1798: AND c.site_use_id = p_customer_site_use_id

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 1859: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b, hz_cust_accounts d

1855: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_cash_receipts_value),0)-
1856: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1857: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
1858: INTO l_tot_sales_in_year
1859: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b, hz_cust_accounts d
1860: WHERE c.org_id = b.org_id
1861: AND c.cust_account_id = d.cust_account_id
1862: AND d.party_id = p_party_id
1863: AND b.set_of_books_id = a.set_of_books_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 1904: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

1900: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_cash_receipts_value),0)-
1901: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1902: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
1903: INTO l_tot_sales_in_year
1904: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
1905: WHERE c.org_id = b.org_id
1906: AND c.cust_account_id = p_cust_account_id
1907: AND b.set_of_books_id = a.set_of_books_id
1908: and as_of_date between TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate);

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 1947: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

1943: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_cash_receipts_value),0)-
1944: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1945: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
1946: INTO l_tot_sales_in_year
1947: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
1948: WHERE c.org_id = b.org_id
1949: AND c.site_use_id = p_customer_site_use_id
1950: AND b.set_of_books_id = a.set_of_books_id
1951: and as_of_date between TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate);

Line 2035: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b , hz_cust_accounts d

2031: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2032: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0)+
2033: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2034: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0)) amount ,to_char(c.as_of_date,'MM') month
2035: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b , hz_cust_accounts d
2036: WHERE c.cust_account_id = d.cust_account_id
2037: AND d.party_id = p_party_id
2038: and c.org_id = b.org_id
2039: AND b.set_of_books_id = a.set_of_books_id

Line 2054: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

2050: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2051: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0)+
2052: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2053: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0)) amount ,to_char(c.as_of_date,'MM') month
2054: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
2055: WHERE c.cust_account_id = p_cust_account_id
2056: and c.org_id = b.org_id
2057: AND b.set_of_books_id = a.set_of_books_id
2058: AND c.as_of_date between TRUNC(sysdate-365) AND TRUNC(sysdate)

Line 2072: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

2068: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2069: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0)+
2070: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2071: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0)) amount ,to_char(c.as_of_date,'MM') month
2072: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
2073: WHERE c.site_use_id = p_customer_site_use_id
2074: and c.org_id = b.org_id
2075: AND b.set_of_books_id = a.set_of_books_id
2076: AND c.as_of_date between TRUNC(sysdate-365) AND TRUNC(sysdate)

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;

Line 2291: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b, hz_cust_accounts d

2287: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_bills_receivables_value),0)+
2288: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2289: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
2290: INTO l_tot_bal
2291: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b, hz_cust_accounts d
2292: WHERE c.cust_account_id = d.cust_account_id
2293: AND d.party_id = p_party_id
2294: and c.org_id = b.org_id
2295: AND b.set_of_books_id = a.set_of_books_id

Line 2311: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

2307: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_bills_receivables_value),0)+
2308: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2309: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
2310: INTO l_tot_bal
2311: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
2312: WHERE c.cust_account_id = p_cust_account_id
2313: and c.org_id = b.org_id
2314: AND b.set_of_books_id = a.set_of_books_id
2315: and as_of_date between (trunc(sysdate) - b.cer_dso_days) AND TRUNC(sysdate);

Line 2330: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

2326: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_bills_receivables_value),0)+
2327: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2328: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
2329: INTO l_tot_bal
2330: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
2331: WHERE c.site_use_id = p_customer_site_use_id
2332: and c.org_id = b.org_id
2333: AND b.set_of_books_id = a.set_of_books_id
2334: and as_of_date between (trunc(sysdate) - b.cer_dso_days) AND TRUNC(sysdate);

Line 2340: SELECT cer_dso_days INTO l_dso_days FROM ar_system_parameters;

2336: END IF;
2337: END IF;
2338:
2339:
2340: SELECT cer_dso_days INTO l_dso_days FROM ar_system_parameters;
2341:
2342: fnd_file.put_line(FND_FILE.LOG,'GET_CONV_DSO_OCM l_tot_bal '||l_tot_bal);
2343: l_conv_dso := l_op_bal/l_tot_bal*l_dso_days;
2344: --fnd_file.put_line(FND_FILE.LOG,'l_conv_dso '||l_conv_dso);

Line 2449: ar_system_parameters b,

2445: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2446: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_count),0))
2447: INTO l_nsf_count
2448: from gl_sets_of_books a,
2449: ar_system_parameters b,
2450: ar_trx_summary c,
2451: hz_cust_accounts d
2452: where a.set_of_books_id = b.set_of_books_id
2453: and b.org_id = c.org_id

Line 2462: ar_system_parameters b,

2458: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2459: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_count),0))
2460: INTO l_nsf_count
2461: from gl_sets_of_books a,
2462: ar_system_parameters b,
2463: ar_trx_summary c
2464: where a.set_of_books_id = b.set_of_books_id
2465: and b.org_id = c.org_id
2466: and c.cust_account_id = p_cust_account_id

Line 2473: ar_system_parameters b,

2469: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2470: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_count),0))
2471: INTO l_nsf_count
2472: from gl_sets_of_books a,
2473: ar_system_parameters b,
2474: ar_trx_summary c
2475: where a.set_of_books_id = b.set_of_books_id
2476: and b.org_id = c.org_id
2477: AND c.site_use_id = p_customer_site_use_id

Line 2503: ar_system_parameters b,

2499: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2500: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
2501: INTO l_nsf_amount
2502: from gl_sets_of_books a,
2503: ar_system_parameters b,
2504: ar_trx_summary c,
2505: hz_cust_accounts d
2506: where a.set_of_books_id = b.set_of_books_id
2507: and b.org_id = c.org_id

Line 2516: ar_system_parameters b,

2512: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2513: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
2514: INTO l_nsf_amount
2515: from gl_sets_of_books a,
2516: ar_system_parameters b,
2517: ar_trx_summary c
2518: where a.set_of_books_id = b.set_of_books_id
2519: and b.org_id = c.org_id
2520: and c.cust_account_id = p_cust_account_id

Line 2527: ar_system_parameters b,

2523: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2524: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
2525: INTO l_nsf_amount
2526: from gl_sets_of_books a,
2527: ar_system_parameters b,
2528: ar_trx_summary c
2529: where a.set_of_books_id = b.set_of_books_id
2530: and b.org_id = c.org_id
2531: AND c.site_use_id = p_customer_site_use_id

Line 2560: ar_system_parameters b ,

2556: DECODE(SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0)))),0,1,
2557: SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0))))),2)
2558: INTO l_wt_days_paid_late
2559: FROM gl_sets_of_books a,
2560: ar_system_parameters b ,
2561: ar_trx_summary c ,
2562: hz_cust_accounts d
2563: WHERE a.set_of_books_id = b.set_of_books_id
2564: AND b.org_id = c.org_id

Line 2574: ar_system_parameters b ,

2570: DECODE(SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0)))),0,1,
2571: SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0))))),2)
2572: INTO l_wt_days_paid_late
2573: FROM gl_sets_of_books a,
2574: ar_system_parameters b ,
2575: ar_trx_summary c
2576: -- , hz_cust_accounts d commented for Bug14167214 by bibeura
2577: WHERE a.set_of_books_id = b.set_of_books_id
2578: AND b.org_id = c.org_id

Line 2587: ar_system_parameters b ,

2583: DECODE(SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0)))),0,1,
2584: SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0))))),2)
2585: INTO l_wt_days_paid_late
2586: FROM gl_sets_of_books a,
2587: ar_system_parameters b ,
2588: ar_trx_summary c
2589: -- , hz_cust_accounts d commented for Bug14167214 by bibeura
2590: WHERE a.set_of_books_id = b.set_of_books_id
2591: AND b.org_id = c.org_id

Line 2617: FROM ar_system_parameters sysp,

2613: c.minimum_accountable_unit
2614: INTO g_curr_rec.base_currency,
2615: g_curr_rec.base_precision,
2616: g_curr_rec.base_min_acc_unit
2617: FROM ar_system_parameters sysp,
2618: gl_sets_of_books sob,
2619: fnd_currencies c
2620: WHERE sob.set_of_books_id = sysp.set_of_books_id
2621: AND sob.currency_code = c.currency_code;