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 481: FROM mtl_system_items

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