DBA Data[Home] [Help]

APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 420: FROM MTL_SECONDARY_INVENTORIES

416:
417: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712
418: CURSOR validate_subinventory(C_ORGANIZATION_ID NUMBER, C_SUBINVENTORY VARCHAR2) IS
419: SELECT status_id
420: FROM MTL_SECONDARY_INVENTORIES
421: WHERE organization_id = C_ORGANIZATION_ID
422: AND secondary_inventory_name = C_SUBINVENTORY;
423:
424: CURSOR validate_inv_loc_id(C_ORGANIZATION_ID NUMBER, C_SUBINVENTORY VARCHAR2, C_INVENTORY_LOCATION_ID NUMBER) IS