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.WSH_EXTERNAL_INTERFACE_SV dependencies on HZ_CUST_ACCOUNTS

Line 298: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP

294: WHERE wsh_location_id=p_location_id;
295:
296: CURSOR get_customer_name(p_customer_id NUMBER) IS
297: SELECT HP.PARTY_NAME
298: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP
299: WHERE HP.PARTY_ID = HCA.PARTY_ID
300: AND HP.PARTY_ID = p_customer_id;
301:
302: l_del_name varchar2(240);

Line 722: FROM HZ_CUST_ACCOUNTS HCA,

718: cursor get_loc_id_cur is
719: SELECT HL.LOCATION_ID,
720: HCA.CUST_ACCOUNT_ID,
721: HCSU.SITE_USE_ID
722: FROM HZ_CUST_ACCOUNTS HCA,
723: HZ_PARTIES HP,
724: HZ_CUST_SITE_USES_ALL HCSU,
725: HZ_CUST_ACCT_SITES_ALL HCAS,
726: -- ORG_ORGANIZATION_DEFINITIONS OOD,

Line 753: HZ_CUST_ACCOUNTS HCA,

749: HCSU.SITE_USE_ID
750: FROM HZ_CUST_SITE_USES_ALL HCSU,
751: HZ_CUST_ACCT_SITES_ALL HCAS,
752: HZ_PARTY_SITES HPS,
753: HZ_CUST_ACCOUNTS HCA,
754: HZ_CUST_ACCT_RELATE_ALL HCAR,
755: HZ_PARTIES HP
756: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
757: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID