APPS.RCV_ROI_TRANSACTION dependencies on MTL_ITEM_LOCATIONS

Line 208: mtl_item_locations mil

204: BEGIN
205: SELECT mld.locator_id
206: INTO x_cascaded_table(n).locator_id
207: FROM mtl_item_loc_defaults mld,
208: mtl_item_locations mil
209: WHERE mld.inventory_item_id = x_cascaded_table(n).item_id
210: AND mld.organization_id = x_cascaded_table(n).to_organization_id
211: AND mld.subinventory_code = x_cascaded_table(n).subinventory
212: AND mld.default_type = 2

Line 256: mtl_item_locations mil

252: l_segmentarray(10), l_segmentarray(11), l_segmentarray(12),
253: l_segmentarray(13), l_segmentarray(14), l_segmentarray(15),
254: l_segmentarray(16), l_segmentarray(17), l_segmentarray(18)
255: FROM mtl_item_loc_defaults mld,
256: mtl_item_locations mil
257: WHERE mld.inventory_item_id = x_cascaded_table(n).item_id
258: AND mld.organization_id = x_cascaded_table(n).to_organization_id
259: AND mld.subinventory_code = x_cascaded_table(n).subinventory
260: AND mld.default_type = 2

Line 290: update mtl_item_locations

286: RETURN;
287:
288: END IF;
289:
290: update mtl_item_locations
291: set subinventory_code = x_cascaded_table(n).subinventory,
292: status_id = inv_material_status_pkg.get_default_locator_status(x_cascaded_table(n).to_organization_id, x_cascaded_table(n).subinventory),
293: physical_location_id = l_loc_id
294: where inventory_location_id = x_cascaded_table(n).locator_id;

Line 2530: FROM mtl_item_locations_kfv ml

2526: END IF;
2527:
2528: SELECT MAX(ml.inventory_location_id)
2529: INTO x_cascaded_table(n).from_locator_id
2530: FROM mtl_item_locations_kfv ml
2531: WHERE ml.concatenated_segments = x_cascaded_table(n).from_locator
2532: AND ( ml.disable_date > SYSDATE
2533: OR ml.disable_date IS NULL)
2534: AND NVL(ml.subinventory_code, 'z') = NVL(x_cascaded_table(n).from_subinventory, 'z')

Line 2564: FROM mtl_item_locations_kfv ml

2560: END IF;
2561:
2562: SELECT MAX(ml.inventory_location_id)
2563: INTO x_cascaded_table(n).locator_id
2564: FROM mtl_item_locations_kfv ml
2565: WHERE ml.concatenated_segments = x_cascaded_table(n).LOCATOR
2566: AND ( ml.disable_date > SYSDATE
2567: OR ml.disable_date IS NULL)
2568: AND NVL(ml.subinventory_code, 'z') = NVL(x_cascaded_table(n).subinventory, 'z')