APPS.WMS_MDC_PVT dependencies on MTL_ITEM_LOCATIONS

Line 511: FROM mtl_item_locations mil

507: END IF;
508: BEGIN
509: SELECT 'Y'
510: INTO l_in_staging
511: FROM mtl_item_locations mil
512: WHERE mil.organization_id = l_to_lpn_organization_id
513: AND mil.subinventory_code = p_to_sub
514: AND mil.inventory_location_id = p_to_locator_id
515: AND mil.inventory_location_type = 2;

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 885: , mtl_item_locations mil

881: FROM
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

Line 927: , mtl_item_locations mil

923: FROM
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

Line 974: , mtl_item_locations mil

970: FROM
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