APPS.WMS_MDC_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 91: FROM wms_license_plate_numbers

87: 'wms_mdc_pvt.get_delivery_id');
88: END IF;
89: SELECT lpn_context
90: INTO l_lpn_context
91: FROM wms_license_plate_numbers
92: WHERE lpn_id = p_lpn_id;
93:
94: IF g_debug = 1 THEN
95: debug('LPN Context : ' || l_lpn_context, 'wms_mdc_pvt.get_delivery_id');

Line 176: FROM wms_license_plate_numbers wlpn

172: INTO l_delivery_id
173: FROM mtl_txn_request_lines mtrl,
174: wsh_delivery_assignments_v wda
175: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
176: FROM wms_license_plate_numbers wlpn
177: START WITH wlpn.lpn_id = p_lpn_id
178: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id)
179: AND wda.delivery_detail_id = mtrl.backorder_delivery_detail_id;
180: EXCEPTION

Line 271: FROM wms_license_plate_numbers wlpn

267: FROM wms_op_plan_details wopd,
268: mtl_material_transactions_temp mmtt,
269: mtl_txn_request_lines mtrl
270: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
271: FROM wms_license_plate_numbers wlpn
272: START WITH wlpn.lpn_id = p_lpn_id
273: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id)
274: AND mtrl.line_status = 7
275: AND mtrl.line_id = mmtt.move_order_line_id

Line 324: FROM wms_license_plate_numbers wlpn

320: FUNCTION is_mdc_lpn(p_lpn_id IN NUMBER) RETURN BOOLEAN IS
321:
322: CURSOR lpn_cursor IS
323: SELECT wlpn.lpn_id, lpn_context
324: FROM wms_license_plate_numbers wlpn
325: WHERE wlpn.outermost_lpn_id = p_lpn_id;
326:
327: --l_lpn_context NUMBER;
328: l_loose_exists VARCHAR2(1);

Line 484: FROM wms_license_plate_numbers

480: null;
481: ELSE
482: SELECT lpn_context , organization_id, outermost_lpn_id
483: INTO l_to_lpn_context , l_to_lpn_organization_id, l_outermost_lpn_id
484: FROM wms_license_plate_numbers
485: WHERE lpn_id = p_to_lpn_id;
486: IF g_debug = 1 THEN
487: debug('l_to_lpn_context for p_to_lpn_id : ' || l_to_lpn_context
488: || ': '

Line 626: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn

622: END IF;
623: BEGIN
624: SELECT 'Y'
625: INTO l_in_staging
626: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn
627: WHERE wlpn.lpn_id = p_to_lpn_id
628: AND wlpn.locator_id = mil.inventory_location_id
629: AND mil.inventory_location_type = 2;
630: EXCEPTION

Line 886: , wms_license_plate_numbers wlpn

882: (SELECT wlpn.outermost_lpn_id, wlpn.subinventory_code, wlpn.locator_id
883: FROM wsh_delivery_assignments wda
884: , wsh_delivery_details_ob_grp_v wdd
885: , mtl_item_locations mil
886: , wms_license_plate_numbers wlpn
887: , wms_dispatched_tasks_history wdth
888: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
889: AND wdd.lpn_id = wlpn.lpn_id
890: AND wlpn.lpn_id <> p_lpn_id

Line 928: , wms_license_plate_numbers wlpn

924: (SELECT wlpn.outermost_lpn_id, wlpn.subinventory_code, wlpn.locator_id
925: FROM wsh_delivery_assignments wda
926: , wsh_delivery_details_ob_grp_v wdd
927: , mtl_item_locations mil
928: , wms_license_plate_numbers wlpn
929: , wms_dispatched_tasks_history wdth
930: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
931: AND wdd.lpn_id = wlpn.lpn_id
932: AND wlpn.lpn_id <> p_lpn_id

Line 975: , wms_license_plate_numbers wlpn

971: (SELECT wlpn.outermost_lpn_id, wlpn.subinventory_code, wlpn.locator_id
972: FROM wsh_delivery_assignments wda
973: , wsh_delivery_details_ob_grp_v wdd
974: , mtl_item_locations mil
975: , wms_license_plate_numbers wlpn
976: , wms_dispatched_tasks_history wdth
977: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
978: AND wdd.lpn_id = wlpn.lpn_id
979: AND wlpn.lpn_id <> p_lpn_id