APPS.WMS_MDC_PVT dependencies on MTL_ITEM_LOCATIONS

Line 474: FROM mtl_item_locations mil

470: END IF;
471: BEGIN
472: SELECT 'Y'
473: INTO l_in_staging
474: FROM mtl_item_locations mil
475: WHERE mil.organization_id = l_to_lpn_organization_id
476: AND mil.subinventory_code = p_to_sub
477: AND mil.inventory_location_id = p_to_locator_id
478: AND mil.inventory_location_type = 2;

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

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

Line 890: , mtl_item_locations mil

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

Line 937: , mtl_item_locations mil

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