APPS.WMS_SHIPPING_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 115: FROM wms_license_plate_numbers wlpn,

111: WHERE task_type = 7
112: AND organization_id = l_organization_id
113: AND transfer_lpn_id IN
114: (SELECT wlpn.outermost_lpn_id
115: FROM wms_license_plate_numbers wlpn,
116: wsh_delivery_details wdd,
117: wsh_delivery_assignments_v wda
118: WHERE wda.delivery_detail_id = l_delivery_detail_id
119: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id

Line 133: FROM wms_license_plate_numbers wlpn,

129: WHERE wms_task_type = 7
130: AND organization_id = l_organization_id
131: AND content_lpn_id IN
132: ( SELECT wlpn.outermost_lpn_id
133: FROM wms_license_plate_numbers wlpn,
134: wsh_delivery_details wdd,
135: wsh_delivery_assignments_v wda
136: WHERE wda.delivery_detail_id = l_delivery_detail_id
137: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id

Line 163: IF l_debug = 1 THEN debug('Ready to update wms_license_plate_numbers '); END IF;

159: FETCH get_lpn_id INTO l_outermost_lpn_id;
160: EXIT WHEN get_lpn_id%notfound;
161: -- update lpns with context of picked
162:
163: IF l_debug = 1 THEN debug('Ready to update wms_license_plate_numbers '); END IF;
164:
165: --// Talk to Jason/Tharian **MRANA
166: UPDATE wms_license_plate_numbers
167: SET lpn_context = 11,

Line 166: UPDATE wms_license_plate_numbers

162:
163: IF l_debug = 1 THEN debug('Ready to update wms_license_plate_numbers '); END IF;
164:
165: --// Talk to Jason/Tharian **MRANA
166: UPDATE wms_license_plate_numbers
167: SET lpn_context = 11,
168: last_update_date = Sysdate,
169: last_updated_by = fnd_global.user_id
170: WHERE lpn_id IN (SELECT lpn_id

Line 171: FROM wms_license_plate_numbers

167: SET lpn_context = 11,
168: last_update_date = Sysdate,
169: last_updated_by = fnd_global.user_id
170: WHERE lpn_id IN (SELECT lpn_id
171: FROM wms_license_plate_numbers
172: START WITH lpn_id = l_outermost_lpn_id
173: CONNECT BY parent_lpn_id = PRIOR lpn_id);
174:
175: IF l_debug = 1 THEN

Line 176: debug('Updated wms_license_plate_numbers : ' || l_outermost_lpn_id);

172: START WITH lpn_id = l_outermost_lpn_id
173: CONNECT BY parent_lpn_id = PRIOR lpn_id);
174:
175: IF l_debug = 1 THEN
176: debug('Updated wms_license_plate_numbers : ' || l_outermost_lpn_id);
177: END IF;
178: END LOOP;
179: CLOSE get_lpn_id; */
180: END IF; -- wms_globals.g_ship_confirm_method <> 'DIRECT' THEN