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

Line 426: FROM WSH_LOCATIONS WSH, HZ_LOCATIONS HZ, HZ_PARTY_SITES HPS, HZ_PARTIES HP, FND_TIMEZONES_B TZ --3842898 : Replaced fnd_timezones_vl with fnd_timezones_b

422: WSH.LATITUDE,
423: WSH.LONGITUDE,
424: NVL(TZ.TIMEZONE_CODE, WSH.TIMEZONE_CODE),
425: SYSDATE
426: FROM WSH_LOCATIONS WSH, HZ_LOCATIONS HZ, HZ_PARTY_SITES HPS, HZ_PARTIES HP, FND_TIMEZONES_B TZ --3842898 : Replaced fnd_timezones_vl with fnd_timezones_b
427: WHERE SOURCE_LOCATION_ID between p_from_location and p_to_location
428: AND nvl(hz.last_update_date,sysdate) >= nvl(l_start_date, nvl(hz.last_update_date,sysdate))
429: AND nvl(hz.last_update_date,sysdate) < nvl(l_end_date, nvl(hz.last_update_date,sysdate)+1)
430: AND hz.location_id = wsh.source_location_id

Line 439: FROM hz_party_sites hps1

435: /* in
436: (
437: SELECT first_value(party_site_number)
438: OVER (ORDER BY status ASC) AS party_site_number
439: FROM hz_party_sites hps1
440: WHERE hps1.location_id = hz.location_id
441: )*/
442: AND hz.timezone_id = tz.upgrade_tz_id(+)
443: ORDER BY HZ.LOCATION_ID;

Line 466: FROM HZ_LOCATIONS HZ, HZ_PARTY_SITES HPS, HZ_PARTIES HP, FND_TIMEZONES_VL TZ

462: HP.PARTY_NAME,
463: NULL,
464: NULL,
465: TZ.TIMEZONE_CODE
466: FROM HZ_LOCATIONS HZ, HZ_PARTY_SITES HPS, HZ_PARTIES HP, FND_TIMEZONES_VL TZ
467: WHERE HZ.LOCATION_ID between p_from_location and p_to_location
468: AND nvl(hz.last_update_date,sysdate) >= nvl(l_start_date, nvl(hz.last_update_date,sysdate))
469: AND nvl(hz.last_update_date,sysdate) < nvl(l_end_date, nvl(hz.last_update_date,sysdate)+1)
470: AND hz.location_id NOT IN ( select /*+ INDEX (wl,WSH_LOCATIONS_N1) */

Line 481: FROM hz_party_sites hps1

477: AND hps.party_site_number in
478: (
479: SELECT first_value(party_site_number)
480: OVER (ORDER BY status ASC) AS party_site_number
481: FROM hz_party_sites hps1
482: WHERE hps1.location_id = hz.location_id
483: )
484: AND hz.timezone_id = tz.upgrade_tz_id(+)
485: ORDER BY HZ.LOCATION_ID;

Line 1613: FROM hz_party_sites hps

1609: pUILocationCodeTbl IN OUT NOCOPY LocationCode_Tbl_Type)
1610: IS
1611: CURSOR get_site_number(l_location_id NUMBER) IS
1612: SELECT party_site_number
1613: FROM hz_party_sites hps
1614: WHERE hps.location_id = l_location_id;
1615:
1616: i NUMBER;
1617: l_site_number1 VARCHAR2(30);

Line 1964: FROM hz_party_sites ps

1960: */
1961:
1962: CURSOR get_party_info(c_location_id IN NUMBER) IS
1963: SELECT distinct ps.party_id
1964: FROM hz_party_sites ps
1965: WHERE ps.location_id = c_location_id;
1966:
1967: -- TODO
1968: -- might not be tied to internal org

Line 2406: HZ_PARTY_SITES sites

2402: SELECT ploc.LOCATION_ID internal_org_location_id
2403: FROM PO_LOCATION_ASSOCIATIONS_ALL ploc,
2404: hz_cust_site_uses_all site_uses,
2405: hz_cust_acct_sites_all acct_sites,
2406: HZ_PARTY_SITES sites
2407: WHERE ploc.SITE_USE_ID = site_uses.SITE_USE_ID
2408: AND site_uses.CUST_ACCT_SITE_ID = acct_sites.CUST_ACCT_SITE_ID
2409: AND acct_sites.PARTY_SITE_ID = sites.PARTY_SITE_ID
2410: AND ploc.CUSTOMER_ID = acct_sites.CUST_ACCOUNT_ID