APPS.INV_VALIDATE_TROLIN dependencies on MTL_ITEM_LOCATIONS

Line 1351: FROM MTL_ITEM_LOCATIONS

1347: l_combination_id := FND_FLEX_KEYVAL.combination_id;
1348: BEGIN
1349: SELECT 'EXISTS'
1350: INTO l_temp
1351: FROM MTL_ITEM_LOCATIONS
1352: WHERE INVENTORY_LOCATION_ID = l_combination_id
1353: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id
1354: AND SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name;
1355:

Line 1358: UPDATE mtl_item_locations

1354: AND SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name;
1355:
1356: EXCEPTION
1357: WHEN NO_DATA_FOUND THEN
1358: UPDATE mtl_item_locations
1359: SET SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name
1360: WHERE INVENTORY_LOCATION_ID = l_combination_id
1361: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id
1362: AND SUBINVENTORY_CODE = NULL;

Line 1370: FROM MTL_ITEM_LOCATIONS

1366: return;
1367: else
1368: SELECT PROJECT_ID,TASK_ID
1369: INTO l_project_id, l_task_id
1370: FROM MTL_ITEM_LOCATIONS
1371: WHERE INVENTORY_LOCATION_ID = l_combination_id
1372: AND ORGANIZATION_ID =inv_validate_trohdr.g_org.organization_id;
1373:
1374: if NOT INV_ProjectLocator_PUB.Check_Project_References(

Line 1412: FROM MTL_ITEM_LOCATIONS

1408: do not consider the project and task
1409: */
1410: SELECT PROJECT_ID
1411: INTO l_project_id_mil
1412: FROM MTL_ITEM_LOCATIONS
1413: WHERE INVENTORY_LOCATION_ID = g_to_locator.inventory_location_id
1414: AND ORGANIZATION_ID = p_trolin_rec.organization_id;
1415:
1416: