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_TRX_SUMMARY

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 1614: ar_trx_summary c,

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
1618: AND c.cust_account_id = d.cust_account_id

Line 1633: ar_trx_summary c

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
1637: and as_of_date BETWEEN p_start_date AND p_end_date;

Line 1650: ar_trx_summary c

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
1654: and as_of_date BETWEEN p_start_date AND p_end_date;

Line 1681: ar_trx_summary c,

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
1685: AND c.cust_account_id = d.cust_account_id

Line 1694: ar_trx_summary c

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
1698: and as_of_date BETWEEN p_start_date AND p_end_date;

Line 1705: ar_trx_summary c

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
1709: and as_of_date BETWEEN p_start_date AND p_end_date;

Line 1747: ar_trx_summary c,

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
1751: AND c.cust_account_id = d.cust_account_id

Line 1772: ar_trx_summary c

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
1776: and as_of_date BETWEEN p_start_date AND p_end_date;

Line 1795: ar_trx_summary c

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
1799: and as_of_date BETWEEN p_start_date AND p_end_date;

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 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 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 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 2450: ar_trx_summary c,

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
2454: AND c.cust_account_id = d.cust_account_id

Line 2463: ar_trx_summary c

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
2467: and as_of_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate);

Line 2474: ar_trx_summary c

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
2478: and as_of_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate);

Line 2504: ar_trx_summary c,

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
2508: AND c.cust_account_id = d.cust_account_id

Line 2517: ar_trx_summary c

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
2521: and as_of_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate);

Line 2528: ar_trx_summary c

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
2532: and as_of_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate);

Line 2561: ar_trx_summary c ,

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
2565: AND c.cust_account_id = d.cust_account_id

Line 2575: ar_trx_summary c

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
2579: AND c.cust_account_id = p_cust_account_id

Line 2588: ar_trx_summary c

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
2592: AND c.site_use_id = p_customer_site_use_id