eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_VALIDATE_TROLIN dependencies on MTL_ITEM_LOCATIONS

Line 1337: FROM MTL_ITEM_LOCATIONS

1333: l_combination_id := FND_FLEX_KEYVAL.combination_id;
1334: BEGIN
1335: SELECT 'EXISTS'
1336: INTO l_temp
1337: FROM MTL_ITEM_LOCATIONS
1338: WHERE INVENTORY_LOCATION_ID = l_combination_id
1339: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id
1340: AND SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name;
1341:

Line 1344: UPDATE mtl_item_locations

1340: AND SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name;
1341:
1342: EXCEPTION
1343: WHEN NO_DATA_FOUND THEN
1344: UPDATE mtl_item_locations
1345: SET SUBINVENTORY_CODE = g_to_sub.secondary_inventory_name
1346: WHERE INVENTORY_LOCATION_ID = l_combination_id
1347: AND ORGANIZATION_ID = inv_validate_trohdr.g_org.organization_id
1348: AND SUBINVENTORY_CODE = NULL;

Line 1356: FROM MTL_ITEM_LOCATIONS

1352: return;
1353: else
1354: SELECT PROJECT_ID,TASK_ID
1355: INTO l_project_id, l_task_id
1356: FROM MTL_ITEM_LOCATIONS
1357: WHERE INVENTORY_LOCATION_ID = l_combination_id
1358: AND ORGANIZATION_ID =inv_validate_trohdr.g_org.organization_id;
1359:
1360: if NOT INV_ProjectLocator_PUB.Check_Project_References(

Line 1398: FROM MTL_ITEM_LOCATIONS

1394: do not consider the project and task
1395: */
1396: SELECT PROJECT_ID
1397: INTO l_project_id_mil
1398: FROM MTL_ITEM_LOCATIONS
1399: WHERE INVENTORY_LOCATION_ID = g_to_locator.inventory_location_id
1400: AND ORGANIZATION_ID = p_trolin_rec.organization_id;
1401:
1402: