APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_TRIP_STOPS

Line 92: WSH_TRIP_STOPS WTS

88: FROM HR_ALL_ORGANIZATION_UNITS HOU,
89: WSH_LOCATIONS WL,
90: WSH_NEW_DELIVERIES WND,
91: WSH_DELIVERY_LEGS WDL,
92: WSH_TRIP_STOPS WTS
93: WHERE WTS.STOP_ID = p_stop_id
94: AND HOU.LOCATION_ID = WL.SOURCE_LOCATION_ID
95: AND WL.LOCATION_SOURCE_CODE = 'HR'
96: AND WL.WSH_LOCATION_ID = nvl(WTS.PHYSICAL_LOCATION_ID,WTS.STOP_LOCATION_ID)

Line 108: WSH_TRIP_STOPS WTS

104: cursor l_stop_org_csr(p_stop_id IN NUMBER) is
105: SELECT HL.INVENTORY_ORGANIZATION_ID
106: FROM HR_LOCATIONS_ALL HL,
107: WSH_LOCATIONS WL,
108: WSH_TRIP_STOPS WTS
109: WHERE WTS.STOP_ID = p_stop_id
110: AND HL.LOCATION_ID = WL.SOURCE_LOCATION_ID
111: AND WL.LOCATION_SOURCE_CODE = 'HR'
112: AND WL.WSH_LOCATION_ID = nvl(WTS.PHYSICAL_LOCATION_ID,WTS.STOP_LOCATION_ID);

Line 122: WSH_TRIP_STOPS WTS,

118: HZ_PARTY_SITES HPS,
119: WSH_LOCATIONS WL,
120: WSH_NEW_DELIVERIES WND,
121: WSH_DELIVERY_LEGS WDL,
122: WSH_TRIP_STOPS WTS,
123: WSH_DELIVERY_ASSIGNMENTS WDA,
124: WSH_DELIVERY_DETAILS WDD
125: WHERE WTS.STOP_ID = p_stop_id
126: AND HPS.LOCATION_ID = WL.SOURCE_LOCATION_ID

Line 145: WSH_TRIP_STOPS WTS

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
148: AND WL.LOCATION_SOURCE_CODE = 'HZ'
149: AND WL.WSH_LOCATION_ID = nvl(WTS.PHYSICAL_LOCATION_ID,WTS.STOP_LOCATION_ID)

Line 673: WSH_TRIP_STOPS WTS,

669: -- cursors
670: cursor l_get_del_csr is
671: SELECT DISTINCT WDL.DELIVERY_ID
672: FROM WSH_DELIVERY_LEGS WDL,
673: WSH_TRIP_STOPS WTS,
674: WSH_OTM_LOCATIONS_GTMP WLT
675: WHERE WTS.TRIP_ID = WLT.LOCATION_ID
676: AND WLT.LOCATION_TYPE = 'TRIP'
677: AND (WTS.STOP_ID = WDL.PICK_UP_STOP_ID

Line 688: FROM WSH_TRIP_STOPS WTS,

684: cursor l_get_stops_csr is
685: SELECT WL.LOCATION_SOURCE_CODE LOC_TYPE,
686: WTS.STOP_LOCATION_ID LOCATION_ID,
687: WTS.STOP_ID
688: FROM WSH_TRIP_STOPS WTS,
689: WSH_OTM_LOCATIONS_GTMP WLT,
690: WSH_LOCATIONS WL
691: WHERE WTS.TRIP_ID = WLT.LOCATION_ID
692: AND WLT.LOCATION_TYPE = 'TRIP'

Line 2943: FROM WSH_TRIP_STOPS WTS,

2939: IS
2940: cursor l_get_stop_loc_csr is
2941: SELECT WL.LOCATION_SOURCE_CODE LOC_TYPE,
2942: WL.SOURCE_LOCATION_ID LOCATION_ID
2943: FROM WSH_TRIP_STOPS WTS,
2944: WSH_LOCATIONS WL
2945: WHERE WTS.STOP_ID = p_stop_id
2946: AND WL.WSH_LOCATION_ID = nvl(WTS.PHYSICAL_LOCATION_ID,WTS.STOP_LOCATION_ID);
2947: --AND WTS.TMS_INTERFACE_FLAG ='ASP';