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 634: WSH_TRIP_STOPS WTS,

630: -- cursors
631: cursor l_get_del_csr is
632: SELECT DISTINCT WDL.DELIVERY_ID
633: FROM WSH_DELIVERY_LEGS WDL,
634: WSH_TRIP_STOPS WTS,
635: WSH_OTM_LOCATIONS_GTMP WLT
636: WHERE WTS.TRIP_ID = WLT.LOCATION_ID
637: AND WLT.LOCATION_TYPE = 'TRIP'
638: AND (WTS.STOP_ID = WDL.PICK_UP_STOP_ID

Line 649: FROM WSH_TRIP_STOPS WTS,

645: cursor l_get_stops_csr is
646: SELECT WL.LOCATION_SOURCE_CODE LOC_TYPE,
647: WTS.STOP_LOCATION_ID LOCATION_ID,
648: WTS.STOP_ID
649: FROM WSH_TRIP_STOPS WTS,
650: WSH_OTM_LOCATIONS_GTMP WLT,
651: WSH_LOCATIONS WL
652: WHERE WTS.TRIP_ID = WLT.LOCATION_ID
653: AND WLT.LOCATION_TYPE = 'TRIP'

Line 2904: FROM WSH_TRIP_STOPS WTS,

2900: IS
2901: cursor l_get_stop_loc_csr is
2902: SELECT WL.LOCATION_SOURCE_CODE LOC_TYPE,
2903: WL.SOURCE_LOCATION_ID LOCATION_ID
2904: FROM WSH_TRIP_STOPS WTS,
2905: WSH_LOCATIONS WL
2906: WHERE WTS.STOP_ID = p_stop_id
2907: AND WL.WSH_LOCATION_ID = nvl(WTS.PHYSICAL_LOCATION_ID,WTS.STOP_LOCATION_ID);
2908: --AND WTS.TMS_INTERFACE_FLAG ='ASP';