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_OTM_REF_DATA_GEN_PKG dependencies on HZ_PARTY_SITES

Line 118: HZ_PARTY_SITES HPS,

114: cursor l_stop_dd_cust_csr(p_stop_id IN NUMBER) is
115: SELECT HCA.CUST_ACCOUNT_ID
116: FROM HZ_CUST_ACCOUNTS HCA,
117: HZ_PARTIES HP,
118: HZ_PARTY_SITES HPS,
119: WSH_LOCATIONS WL,
120: WSH_NEW_DELIVERIES WND,
121: WSH_DELIVERY_LEGS WDL,
122: WSH_TRIP_STOPS WTS,

Line 143: HZ_PARTY_SITES HPS,

139: cursor l_stop_cust_csr(p_stop_id IN NUMBER) is
140: SELECT HCA.CUST_ACCOUNT_ID
141: FROM HZ_CUST_ACCOUNTS HCA,
142: HZ_PARTIES HP,
143: HZ_PARTY_SITES HPS,
144: WSH_LOCATIONS WL,
145: WSH_TRIP_STOPS WTS
146: WHERE WTS.STOP_ID = p_stop_id
147: AND HPS.LOCATION_ID = WL.SOURCE_LOCATION_ID

Line 313: HZ_PARTY_SITES HPS,

309: SELECT DISTINCT HCAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID,
310: WDD.CUSTOMER_ID CUSTOMER_ID
311: FROM WSH_DELIVERY_DETAILS WDD,
312: WSH_DELIVERY_ASSIGNMENTS WDA,
313: HZ_PARTY_SITES HPS,
314: WSH_LOCATIONS WSL,
315: HZ_CUST_ACCT_SITES_ALL HCAS,
316: HZ_CUST_ACCOUNT_ROLES HCAR
317: WHERE WDA.delivery_id = p_delivery_id

Line 862: from hz_party_sites

858: l_num_warnings NUMBER := 0;
859:
860: cursor l_get_loc_id_csr (p_party_id IN NUMBER, p_party_site_id IN NUMBER) IS
861: select location_id
862: from hz_party_sites
863: where party_site_id = p_party_site_id
864: and party_id = p_party_id;
865: -- bug 5118375
866:

Line 1543: HZ_PARTY_SITES HPS,

1539: FND_TERRITORIES FNDTR,
1540: WSH_OTM_LOCATIONS_GTMP wlt,
1541: WSH_CARRIERS WCV,
1542: WSH_CARRIER_SITES WCS,
1543: HZ_PARTY_SITES HPS,
1544: HZ_PARTIES HP,
1545: WSH_LOCATIONS WSL
1546: WHERE WCV.CARRIER_ID = HPS.PARTY_ID
1547: AND HPS.LOCATION_ID = HZL.LOCATION_ID