APPS.WIP_LOCATOR dependencies on MTL_ITEM_LOCATIONS

Line 122: FROM MTL_ITEM_LOCATIONS

118: AND x_loc_control = WIP_CONSTANTS.PRESPECIFIED THEN
119:
120: SELECT COUNT(*)
121: INTO x_count
122: FROM MTL_ITEM_LOCATIONS
123: WHERE (DISABLE_DATE > SYSDATE or
124: DISABLE_DATE IS NULL)
125: AND SUBINVENTORY_CODE = P_Subinventory_Code
126: AND INVENTORY_LOCATION_ID = P_Locator_Id

Line 138: FROM MTL_ITEM_LOCATIONS

134: ELSE
135:
136: SELECT COUNT(*)
137: INTO x_count
138: FROM MTL_ITEM_LOCATIONS
139: WHERE (DISABLE_DATE > SYSDATE or
140: DISABLE_DATE IS NULL)
141: AND INVENTORY_LOCATION_ID = P_Locator_Id
142: AND NVL(SUBINVENTORY_CODE,'Z')

Line 165: UPDATE MTL_ITEM_LOCATIONS

161:
162: P_Locator_Id := FND_FLEX_KEYVAL.COMBINATION_ID;
163:
164: IF x_loc_control = WIP_CONSTANTS.DYNAMIC THEN
165: UPDATE MTL_ITEM_LOCATIONS
166: SET SUBINVENTORY_CODE = P_Subinventory_Code
167: WHERE INVENTORY_LOCATION_ID = P_Locator_Id
168: AND ORGANIZATION_ID = P_Organization_Id;
169: END IF;