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.JAI_AR_EER1_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2587: FROM JAI_CMN_RG_23AC_II_TRXS JIRP,JAI_CMN_CUS_ADDRESSES JICA,hz_cust_acct_sites_all HZCAS,hz_cust_site_uses_all HZCSU

2583:
2584: CURSOR Cur_crdit_input_cust
2585: IS
2586: SELECT SUM(DECODE(register_type, 'A', nvl(cr_basic_ed,0) + nvl(cr_additional_ed,0) + nvl(cr_other_ed,0),0)) credit_availed_on_inputs_cust
2587: FROM JAI_CMN_RG_23AC_II_TRXS JIRP,JAI_CMN_CUS_ADDRESSES JICA,hz_cust_acct_sites_all HZCAS,hz_cust_site_uses_all HZCSU
2588: WHERE HZCAS.cust_acct_site_id = HZCSU.cust_acct_site_id
2589: AND JICA.address_id = HZCSU.cust_acct_site_id
2590: AND HZCSU.site_use_id = JIRP.customer_site_id
2591: AND JIRP.customer_id = JICA.customer_id

Line 2706: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_CUS_ADDRESSES JICA,hz_cust_acct_sites_all HZCAS,hz_cust_site_uses_all HZCSU

2702: AND to_char(rg23.creation_date, 'YYYY') || to_char(rg23.creation_date, 'MM') = ln_yyyymm ;
2703:
2704: CURSOR Cur_cess_excise_input_cust
2705: IS
2706: SELECT NVL(SUM(credit),0) FROM JAI_CMN_RG_OTHERS JRO,JAI_CMN_RG_23AC_II_TRXS RG23,JAI_CMN_CUS_ADDRESSES JICA,hz_cust_acct_sites_all HZCAS,hz_cust_site_uses_all HZCSU
2707: WHERE hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id
2708: and jica.address_id = hzcsu.cust_acct_site_id
2709: and hzcsu.site_use_id = rg23.customer_site_id
2710: and rg23.customer_id = jica.customer_id