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 HZ_CUSTOMER_PROFILES

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 632: HZ_CUSTOMER_PROFILES CPF,

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
636: AND CPF.CUST_ACCOUNT_ID =AUAS.CUSTOMER_ID

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 690: HZ_CUSTOMER_PROFILES CPF,

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
694: CPF.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID AND