APPS.INV_VALIDATE dependencies on MTL_ITEM_LOCATIONS

Line 1201: FROM MTL_ITEM_LOCATIONS

1197: if(NVL(v_locator_control,1) = 2) then
1198: if (p_item.restrict_locators_code = 1) then -- if restricted
1199: select *
1200: INTO p_locator
1201: FROM MTL_ITEM_LOCATIONS
1202: WHERE ORGANIZATION_ID = p_org.organization_id
1203: AND INVENTORY_LOCATION_ID = p_locator.inventory_location_id
1204: AND SUBINVENTORY_CODE = p_sub.secondary_inventory_name
1205: AND (DISABLE_DATE > SYSDATE OR DISABLE_DATE IS NULL)

Line 1217: FROM MTL_ITEM_LOCATIONS

1213: AND SUBINVENTORY_CODE = p_sub.secondary_inventory_name);
1214: else
1215: SELECT *
1216: INTO p_locator
1217: FROM MTL_ITEM_LOCATIONS
1218: WHERE ORGANIZATION_ID = p_org.organization_id
1219: AND INVENTORY_LOCATION_ID = p_locator.inventory_location_id
1220: AND (NVL(SUBINVENTORY_CODE,p_sub.secondary_inventory_name) =
1221: p_sub.secondary_inventory_name)

Line 1229: FROM MTL_ITEM_LOCATIONS

1225: end if;
1226: elsif NVL(v_locator_control,1) = 3 then -- if dynamic
1227: SELECT *
1228: INTO p_locator
1229: FROM MTL_ITEM_LOCATIONS
1230: WHERE ORGANIZATION_ID = p_org.organization_id
1231: AND INVENTORY_LOCATION_ID = p_locator.inventory_location_id
1232: AND (NVL(SUBINVENTORY_CODE,p_sub.secondary_inventory_name) =
1233: p_sub.secondary_inventory_name)

Line 1671: UPDATE mtl_item_locations

1667: if(p_validation_mode = EXISTS_OR_CREATE
1668: AND FND_FLEX_KEYVAL.new_combination)
1669: then
1670: --inv_debug.message('new combination');
1671: UPDATE mtl_item_locations
1672: SET subinventory_code = p_sub.secondary_inventory_name
1673: ,project_id = p_locator.project_id
1674: ,task_id = p_locator.task_id
1675: ,physical_location_id = p_locator.physical_location_id

Line 1686: FROM mtl_item_locations

1682: END IF;
1683:
1684: SELECT *
1685: INTO p_locator
1686: FROM mtl_item_locations
1687: WHERE organization_id = p_org.organization_id
1688: AND subinventory_code = p_sub.secondary_inventory_name
1689: AND inventory_location_id = p_locator.inventory_location_id
1690: AND NVL(disable_date,SYSDATE) >= SYSDATE;

Line 1738: FROM mtl_item_locations mil,mtl_secondary_locators msl

1734: end if;
1735:
1736: SELECT mil.*
1737: INTO p_locator
1738: FROM mtl_item_locations mil,mtl_secondary_locators msl
1739: WHERE mil.organization_id = p_org.organization_id
1740: AND mil.subinventory_code = p_sub.secondary_inventory_name
1741: AND mil.inventory_location_id = p_locator.inventory_location_id
1742: AND NVL(disable_date,SYSDATE) >= SYSDATE