APPS.WMS_MDC_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 90: FROM wms_license_plate_numbers

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

Line 139: FROM wms_license_plate_numbers wlpn

135: INTO l_delivery_id
136: FROM mtl_txn_request_lines mtrl,
137: wsh_delivery_assignments_v wda
138: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
139: FROM wms_license_plate_numbers wlpn
140: START WITH wlpn.lpn_id = p_lpn_id
141: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id)
142: AND wda.delivery_detail_id = mtrl.backorder_delivery_detail_id;
143: EXCEPTION

Line 234: FROM wms_license_plate_numbers wlpn

230: FROM wms_op_plan_details wopd,
231: mtl_material_transactions_temp mmtt,
232: mtl_txn_request_lines mtrl
233: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
234: FROM wms_license_plate_numbers wlpn
235: START WITH wlpn.lpn_id = p_lpn_id
236: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id)
237: AND mtrl.line_status = 7
238: AND mtrl.line_id = mmtt.move_order_line_id

Line 287: FROM wms_license_plate_numbers wlpn

283: FUNCTION is_mdc_lpn(p_lpn_id IN NUMBER) RETURN BOOLEAN IS
284:
285: CURSOR lpn_cursor IS
286: SELECT wlpn.lpn_id, lpn_context
287: FROM wms_license_plate_numbers wlpn
288: WHERE wlpn.outermost_lpn_id = p_lpn_id;
289:
290: --l_lpn_context NUMBER;
291: l_loose_exists VARCHAR2(1);

Line 447: FROM wms_license_plate_numbers

443: null;
444: ELSE
445: SELECT lpn_context , organization_id, outermost_lpn_id
446: INTO l_to_lpn_context , l_to_lpn_organization_id, l_outermost_lpn_id
447: FROM wms_license_plate_numbers
448: WHERE lpn_id = p_to_lpn_id;
449: IF g_debug = 1 THEN
450: debug('l_to_lpn_context for p_to_lpn_id : ' || l_to_lpn_context
451: || ': '

Line 589: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn

585: END IF;
586: BEGIN
587: SELECT 'Y'
588: INTO l_in_staging
589: FROM mtl_item_locations mil, wms_license_plate_numbers wlpn
590: WHERE wlpn.lpn_id = p_to_lpn_id
591: AND wlpn.locator_id = mil.inventory_location_id
592: AND mil.inventory_location_type = 2;
593: EXCEPTION

Line 849: , wms_license_plate_numbers wlpn

845: (SELECT wlpn.outermost_lpn_id, wlpn.subinventory_code, wlpn.locator_id
846: FROM wsh_delivery_assignments wda
847: , wsh_delivery_details_ob_grp_v wdd
848: , mtl_item_locations mil
849: , wms_license_plate_numbers wlpn
850: , wms_dispatched_tasks_history wdth
851: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
852: AND wdd.lpn_id = wlpn.lpn_id
853: AND wlpn.lpn_id <> p_lpn_id

Line 891: , wms_license_plate_numbers wlpn

887: (SELECT wlpn.outermost_lpn_id, wlpn.subinventory_code, wlpn.locator_id
888: FROM wsh_delivery_assignments wda
889: , wsh_delivery_details_ob_grp_v wdd
890: , mtl_item_locations mil
891: , wms_license_plate_numbers wlpn
892: , wms_dispatched_tasks_history wdth
893: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
894: AND wdd.lpn_id = wlpn.lpn_id
895: AND wlpn.lpn_id <> p_lpn_id

Line 938: , wms_license_plate_numbers wlpn

934: (SELECT wlpn.outermost_lpn_id, wlpn.subinventory_code, wlpn.locator_id
935: FROM wsh_delivery_assignments wda
936: , wsh_delivery_details_ob_grp_v wdd
937: , mtl_item_locations mil
938: , wms_license_plate_numbers wlpn
939: , wms_dispatched_tasks_history wdth
940: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
941: AND wdd.lpn_id = wlpn.lpn_id
942: AND wlpn.lpn_id <> p_lpn_id