[Home] [Help]
3: --
4: -- Package: WSH_LOCATIONS_PKG
5: --
6: -- Purpose: To populate data in WSH_LOCATIONS with the data in
7: -- HZ_LOCATIONS, HR_LOCATIONS and PO_VENDOR_SITES.
8: --
9: --
10:
11: --
346: | |
347: | DESCRIPTION |
348: | |
349: | This procedure will populate the WSH_LOCATIONS table |
350: | with the locations in HZ_LOCATIONS (whose usage is deliver_to |
351: | or ship_to) and HR_LOCATIONS |
352: | |
353: +===========================================================================*/
354:
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
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) */
864: l_previous_rows := l_current_rows ;
865:
866: IF pUpdateLocationIdTbl.COUNT <> 0 THEN
867: IF l_debug_on THEN
868: WSH_DEBUG_SV.logmsg(l_module_name,' found '||pUpdateLocationIdTbl.COUNT||' hz locations for update ');
869: END IF;
870:
871: --
872: --Bug 4995478 Start
1057: END IF;
1058:
1059: IF pInsertLocationIdTbl.COUNT <> 0 THEN
1060: IF l_debug_on THEN
1061: WSH_DEBUG_SV.logmsg(l_module_name,' found '||pInsertLocationIdTbl.COUNT||' hz locations for insert ');
1062: END IF;
1063:
1064: --
1065: --Bug 4995478 Start