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 FND_CURRENCIES_VL

Line 606: FND_CURRENCIES_VL CUR, HZ_CUSTOMER_PROFILES CPF, ar_irec_user_acct_sites_all AUAS

602: IF(p_customer_id IS NULL) THEN
603:
604: select count(*) into l_currency_exist from dual where l_profile_default_currrency in
605: (( SELECT /*+ leading(auas) use_nl(auas cpf) */ unique ( CUR.CURRENCY_CODE ) FROM HZ_CUST_PROFILE_AMTS CPA,
606: FND_CURRENCIES_VL CUR, HZ_CUSTOMER_PROFILES CPF, ar_irec_user_acct_sites_all AUAS
607: WHERE CPA.CURRENCY_CODE = CUR.CURRENCY_CODE
608: AND CPF.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
609: AND CPF.CUST_ACCOUNT_ID =AUAS.CUSTOMER_ID
610: AND (

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 631: FND_CURRENCIES_VL CUR,

627:
628: SELECT /*+ leading(auas) use_nl(auas cpf) */ unique ( CUR.CURRENCY_CODE )
629: INTO l_default_currency
630: FROM HZ_CUST_PROFILE_AMTS CPA,
631: FND_CURRENCIES_VL CUR,
632: HZ_CUSTOMER_PROFILES CPF,
633: ar_irec_user_acct_sites_all AUAS
634: WHERE CPA.CURRENCY_CODE = CUR.CURRENCY_CODE
635: AND CPF.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID

Line 650: SELECT unique ( CUR.CURRENCY_CODE ) INTO l_default_currency FROM FND_CURRENCIES_VL CUR,

646:
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)

Line 663: FND_CURRENCIES_VL CUR, HZ_CUSTOMER_PROFILES CPF, ar_irec_user_acct_sites_all AUAS

659: ELSE
660:
661: select count(*) into l_currency_exist from dual where l_profile_default_currrency in
662: (( SELECT /*+ leading(auas) use_nl(auas cpf) */ unique ( CUR.CURRENCY_CODE ) FROM HZ_CUST_PROFILE_AMTS CPA,
663: FND_CURRENCIES_VL CUR, HZ_CUSTOMER_PROFILES CPF, ar_irec_user_acct_sites_all AUAS
664: WHERE CPA.CURRENCY_CODE = CUR.CURRENCY_CODE
665: AND CPF.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
666: AND CPF.CUST_ACCOUNT_ID = p_customer_id
667: AND (

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 689: FND_CURRENCIES_VL CUR,

685:
686: SELECT /*+ leading(auas) use_nl(auas cpf) */ unique ( CUR.CURRENCY_CODE )
687: INTO l_default_currency
688: FROM HZ_CUST_PROFILE_AMTS CPA,
689: FND_CURRENCIES_VL CUR,
690: HZ_CUSTOMER_PROFILES CPF,
691: ar_irec_user_acct_sites_all AUAS
692: WHERE
693: CPA.CURRENCY_CODE = CUR.CURRENCY_CODE AND

Line 708: SELECT unique ( CUR.CURRENCY_CODE ) INTO l_default_currency FROM FND_CURRENCIES_VL CUR,

704:
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)