DBA Data[Home] [Help]

APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on MTL_ITEM_LOCATIONS

Line 186: FROM MTL_ITEM_LOCATIONS_KFV

182: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712
183: CURSOR get_inv_loc_id(C_ORGANIZATION_ID NUMBER, C_SUBINVENTORY VARCHAR2, C_LOCATOR_SEGMENTS VARCHAR2)
184: IS
185: SELECT INVENTORY_LOCATION_ID
186: FROM MTL_ITEM_LOCATIONS_KFV
187: WHERE ORGANIZATION_ID = C_ORGANIZATION_ID
188: AND SUBINVENTORY_CODE = C_SUBINVENTORY
189: AND CONCATENATED_SEGMENTS = C_LOCATOR_SEGMENTS;
190: -- End Changes by rbhavsar on Nov 27, 2007 for ER 5854712

Line 413: FROM MTL_ITEM_LOCATIONS

409: AND secondary_inventory_name = C_SUBINVENTORY;
410:
411: CURSOR validate_inv_loc_id(C_ORGANIZATION_ID NUMBER, C_SUBINVENTORY VARCHAR2, C_INVENTORY_LOCATION_ID NUMBER) IS
412: SELECT 1
413: FROM MTL_ITEM_LOCATIONS
414: WHERE ORGANIZATION_ID = C_ORGANIZATION_ID
415: AND SUBINVENTORY_CODE = C_SUBINVENTORY
416: AND INVENTORY_LOCATION_ID = C_INVENTORY_LOCATION_ID
417: AND SEGMENT19 IS NULL