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.JA_JAINER1_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1784: HZ_CUST_SITE_USES_ALL HZCSU

1780: FROM
1781: JAI_CMN_RG_23AC_II_TRXS JIRP,
1782: JAI_CMN_CUS_ADDRESSES JICA,
1783: HZ_CUST_ACCT_SITES_ALL HZCAS,
1784: HZ_CUST_SITE_USES_ALL HZCSU
1785: WHERE HZCAS.CUST_ACCT_SITE_ID = HZCSU.CUST_ACCT_SITE_ID
1786: AND JICA.ADDRESS_ID = HZCSU.CUST_ACCT_SITE_ID
1787: AND HZCSU.SITE_USE_ID = JIRP.CUSTOMER_SITE_ID
1788: AND JIRP.CUSTOMER_ID = JICA.CUSTOMER_ID

Line 2049: HZ_CUST_SITE_USES_ALL HZCSU

2045: JAI_CMN_RG_OTHERS JRO,
2046: JAI_CMN_RG_23AC_II_TRXS RG23,
2047: JAI_CMN_CUS_ADDRESSES JICA,
2048: HZ_CUST_ACCT_SITES_ALL HZCAS,
2049: HZ_CUST_SITE_USES_ALL HZCSU
2050: WHERE HZCAS.CUST_ACCT_SITE_ID = HZCSU.CUST_ACCT_SITE_ID
2051: AND JICA.ADDRESS_ID = HZCSU.CUST_ACCT_SITE_ID
2052: AND HZCSU.SITE_USE_ID = RG23.CUSTOMER_SITE_ID
2053: AND RG23.CUSTOMER_ID = JICA.CUSTOMER_ID

Line 2677: HZ_CUST_SITE_USES_ALL HZCSU

2673: JAI_CMN_RG_OTHERS JRO,
2674: JAI_CMN_RG_23AC_II_TRXS RG23,
2675: JAI_CMN_CUS_ADDRESSES JICA,
2676: HZ_CUST_ACCT_SITES_ALL HZCAS,
2677: HZ_CUST_SITE_USES_ALL HZCSU
2678: WHERE HZCAS.CUST_ACCT_SITE_ID = HZCSU.CUST_ACCT_SITE_ID
2679: AND JICA.ADDRESS_ID = HZCSU.CUST_ACCT_SITE_ID
2680: AND HZCSU.SITE_USE_ID = RG23.CUSTOMER_SITE_ID
2681: AND RG23.CUSTOMER_ID = JICA.CUSTOMER_ID