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 325: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP

321: WHERE wsh_location_id=p_location_id;
322:
323: CURSOR get_customer_name(p_customer_id NUMBER) IS
324: SELECT HP.PARTY_NAME
325: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP
326: WHERE HP.PARTY_ID = HCA.PARTY_ID
327: AND HP.PARTY_ID = p_customer_id;
328:
329: l_del_name varchar2(240);

Line 842: FROM HZ_CUST_ACCOUNTS HCA,

838: cursor get_loc_id_cur is
839: SELECT HL.LOCATION_ID,
840: HCA.CUST_ACCOUNT_ID,
841: HCSU.SITE_USE_ID
842: FROM HZ_CUST_ACCOUNTS HCA,
843: HZ_PARTIES HP,
844: HZ_CUST_SITE_USES_ALL HCSU,
845: HZ_CUST_ACCT_SITES_ALL HCAS,
846: -- ORG_ORGANIZATION_DEFINITIONS OOD,

Line 873: HZ_CUST_ACCOUNTS HCA,

869: HCSU.SITE_USE_ID
870: FROM HZ_CUST_SITE_USES_ALL HCSU,
871: HZ_CUST_ACCT_SITES_ALL HCAS,
872: HZ_PARTY_SITES HPS,
873: HZ_CUST_ACCOUNTS HCA,
874: HZ_CUST_ACCT_RELATE_ALL HCAR,
875: HZ_PARTIES HP
876: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
877: AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID