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.ARI_UTILITIES dependencies on AR_TRX_BAL_SUMMARY

Line 618: (SELECT unique ( CUR.CURRENCY_CODE ) FROM FND_CURRENCIES_VL CUR, AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS

614: )
615: AND AUAS.user_id=FND_GLOBAL.USER_ID()
616: AND AUAS.session_id=p_session_id)
617: UNION
618: (SELECT unique ( CUR.CURRENCY_CODE ) FROM FND_CURRENCIES_VL CUR, AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS
619: WHERE ATB.CURRENCY = CUR.CURRENCY_CODE AND
620: ATB.CUST_ACCOUNT_ID = AUAS.CUSTOMER_ID AND
621: (ATB.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID OR ATB.SITE_USE_ID IS NULL)
622: AND AUAS.user_id=FND_GLOBAL.USER_ID()

Line 651: AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS

647: --If currency does not exist in customer profile, then check if currency exist in transactions of the customer
648: if(l_default_currency = '' OR l_default_currency is null) then
649:
650: SELECT unique ( CUR.CURRENCY_CODE ) INTO l_default_currency FROM FND_CURRENCIES_VL CUR,
651: AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS
652: WHERE ATB.CURRENCY = CUR.CURRENCY_CODE AND
653: ATB.CUST_ACCOUNT_ID = AUAS.CUSTOMER_ID AND
654: (ATB.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID OR ATB.SITE_USE_ID IS NULL)
655: AND AUAS.user_id=FND_GLOBAL.USER_ID()

Line 675: (SELECT unique ( CUR.CURRENCY_CODE ) FROM FND_CURRENCIES_VL CUR, AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS

671: )
672: AND AUAS.user_id=FND_GLOBAL.USER_ID()
673: AND AUAS.session_id=p_session_id)
674: UNION
675: (SELECT unique ( CUR.CURRENCY_CODE ) FROM FND_CURRENCIES_VL CUR, AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS
676: WHERE ATB.CURRENCY = CUR.CURRENCY_CODE AND
677: ATB.CUST_ACCOUNT_ID = p_customer_id AND
678: (ATB.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID OR ATB.SITE_USE_ID IS NULL)
679: AND AUAS.user_id=FND_GLOBAL.USER_ID()

Line 709: AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS

705: --If currency does not exist in customer profile, then check if currency exist in transactions of the customer
706: if(l_default_currency = '' OR l_default_currency is null) then
707:
708: SELECT unique ( CUR.CURRENCY_CODE ) INTO l_default_currency FROM FND_CURRENCIES_VL CUR,
709: AR_TRX_BAL_SUMMARY ATB, ar_irec_user_acct_sites_all AUAS
710: WHERE ATB.CURRENCY = CUR.CURRENCY_CODE AND
711: ATB.CUST_ACCOUNT_ID = p_customer_id AND
712: (ATB.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID OR ATB.SITE_USE_ID IS NULL)
713: AND AUAS.user_id=FND_GLOBAL.USER_ID()