APPS.INV_MOVE_ORDER_PUB dependencies on MTL_SYSTEM_ITEMS

Line 325: FROM mtl_system_items

321: l_sub_loc_ctrl NUMBER;
322:
323: CURSOR get_item_loc_ctrl(v_org_id NUMBER, v_item_id NUMBER) IS
324: SELECT location_control_code
325: FROM mtl_system_items
326: WHERE organization_id = v_org_id
327: AND inventory_item_id = v_item_id;
328:
329: l_item_loc_ctrl NUMBER;

Line 439: FROM mtl_system_items

435: ,nvl(restrict_subinventories_code,0)
436: INTO l_primary_uom_code
437: ,l_restrict_locators_code
438: ,l_restrict_subinventories_code
439: FROM mtl_system_items
440: WHERE organization_id = x_trolin_tbl(l_index).organization_id
441: AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id;
442:
443: g_inventory_item_id := x_trolin_tbl(l_index).inventory_item_id;

Line 484: FROM mtl_system_items

480: ,nvl(restrict_subinventories_code,0)
481: INTO l_primary_uom_code
482: ,l_restrict_locators_code
483: ,l_restrict_subinventories_code
484: FROM mtl_system_items
485: WHERE organization_id = x_trolin_tbl(l_index).organization_id
486: AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id;
487:
488: g_inventory_item_id := x_trolin_tbl(l_index).inventory_item_id;

Line 544: FROM mtl_system_items

540: ,nvl(restrict_subinventories_code,0)
541: INTO l_primary_uom_code
542: ,l_restrict_locators_code
543: ,l_restrict_subinventories_code
544: FROM mtl_system_items
545: WHERE organization_id = x_trolin_tbl(l_index).organization_id
546: AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id;
547:
548: g_inventory_item_id := x_trolin_tbl(l_index).inventory_item_id;