APPS.INV_VALIDATE dependencies on MTL_ITEM_LOCATIONS

Line 1195: FROM MTL_ITEM_LOCATIONS

1191: if(NVL(v_locator_control,1) = 2) then
1192: if (p_item.restrict_locators_code = 1) then -- if restricted
1193: select *
1194: INTO p_locator
1195: FROM MTL_ITEM_LOCATIONS
1196: WHERE ORGANIZATION_ID = p_org.organization_id
1197: AND INVENTORY_LOCATION_ID = p_locator.inventory_location_id
1198: AND SUBINVENTORY_CODE = p_sub.secondary_inventory_name
1199: AND (DISABLE_DATE > SYSDATE OR DISABLE_DATE IS NULL)

Line 1211: FROM MTL_ITEM_LOCATIONS

1207: AND SUBINVENTORY_CODE = p_sub.secondary_inventory_name);
1208: else
1209: SELECT *
1210: INTO p_locator
1211: FROM MTL_ITEM_LOCATIONS
1212: WHERE ORGANIZATION_ID = p_org.organization_id
1213: AND INVENTORY_LOCATION_ID = p_locator.inventory_location_id
1214: AND (NVL(SUBINVENTORY_CODE,p_sub.secondary_inventory_name) =
1215: p_sub.secondary_inventory_name)

Line 1223: FROM MTL_ITEM_LOCATIONS

1219: end if;
1220: elsif NVL(v_locator_control,1) = 3 then -- if dynamic
1221: SELECT *
1222: INTO p_locator
1223: FROM MTL_ITEM_LOCATIONS
1224: WHERE ORGANIZATION_ID = p_org.organization_id
1225: AND INVENTORY_LOCATION_ID = p_locator.inventory_location_id
1226: AND (NVL(SUBINVENTORY_CODE,p_sub.secondary_inventory_name) =
1227: p_sub.secondary_inventory_name)

Line 1546: UPDATE mtl_item_locations

1542: if(p_validation_mode = EXISTS_OR_CREATE
1543: AND FND_FLEX_KEYVAL.new_combination)
1544: then
1545: --inv_debug.message('new combination');
1546: UPDATE mtl_item_locations
1547: SET subinventory_code = p_sub.secondary_inventory_name
1548: ,project_id = p_locator.project_id
1549: ,task_id = p_locator.task_id
1550: ,physical_location_id = p_locator.physical_location_id

Line 1561: FROM mtl_item_locations

1557: END IF;
1558:
1559: SELECT *
1560: INTO p_locator
1561: FROM mtl_item_locations
1562: WHERE organization_id = p_org.organization_id
1563: AND subinventory_code = p_sub.secondary_inventory_name
1564: AND inventory_location_id = p_locator.inventory_location_id
1565: AND NVL(disable_date,SYSDATE) >= SYSDATE;

Line 1613: FROM mtl_item_locations mil,mtl_secondary_locators msl

1609: end if;
1610:
1611: SELECT mil.*
1612: INTO p_locator
1613: FROM mtl_item_locations mil,mtl_secondary_locators msl
1614: WHERE mil.organization_id = p_org.organization_id
1615: AND mil.subinventory_code = p_sub.secondary_inventory_name
1616: AND mil.inventory_location_id = p_locator.inventory_location_id
1617: AND NVL(disable_date,SYSDATE) >= SYSDATE