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_JAIN23D_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 20: HZ_CUST_SITE_USES_ALL H

16: JAI_CMN_CUS_ADDRESSES F,
17: HZ_LOCATIONS G,
18: HZ_PARTY_SITES HZPS,
19: HZ_CUST_ACCT_SITES_ALL HZCAS,
20: HZ_CUST_SITE_USES_ALL H
21: WHERE E.PARTY_ID = HZCA.PARTY_ID
22: AND HZCA.CUST_ACCOUNT_ID = F.CUSTOMER_ID
23: AND F.ADDRESS_ID = H.CUST_ACCT_SITE_ID
24: AND G.LOCATION_ID = HZPS.LOCATION_ID

Line 103: HZ_CUST_SITE_USES_ALL H

99: JAI_CMN_CUS_ADDRESSES F,
100: HZ_LOCATIONS G,
101: HZ_PARTY_SITES HZPS,
102: HZ_CUST_ACCT_SITES_ALL HZCAS,
103: HZ_CUST_SITE_USES_ALL H
104: WHERE HZCA.CUST_ACCOUNT_ID = P_CUSTOMER_ID
105: AND E.PARTY_ID = HZCA.PARTY_ID
106: AND H.SITE_USE_ID = P_CUSTOMER_SITE_ID
107: AND F.CUSTOMER_ID = HZCA.CUST_ACCOUNT_ID

Line 211: HZ_CUST_SITE_USES_ALL H

207: JAI_CMN_CUS_ADDRESSES F,
208: HZ_LOCATIONS G,
209: HZ_PARTY_SITES HZPS,
210: HZ_CUST_ACCT_SITES_ALL HZCAS,
211: HZ_CUST_SITE_USES_ALL H
212: WHERE E.PARTY_ID = HZCA.PARTY_ID
213: AND HZCA.CUST_ACCOUNT_ID = F.CUSTOMER_ID
214: AND F.ADDRESS_ID = HZCAS.CUST_ACCT_SITE_ID
215: AND G.LOCATION_ID = HZPS.PARTY_SITE_ID

Line 470: HZ_CUST_SITE_USES_ALL H

466: JAI_CMN_CUS_ADDRESSES F,
467: HZ_LOCATIONS G,
468: HZ_PARTY_SITES HZPS,
469: HZ_CUST_ACCT_SITES_ALL HZCAS,
470: HZ_CUST_SITE_USES_ALL H
471: WHERE E.PARTY_ID = HZCA.CUST_ACCOUNT_ID
472: AND HZCA.CUST_ACCOUNT_ID = F.CUSTOMER_ID
473: AND F.ADDRESS_ID = HZCAS.CUST_ACCT_SITE_ID
474: AND HZCAS.CUST_ACCT_SITE_ID = H.CUST_ACCT_SITE_ID