DBA Data[Home] [Help]

APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 407: FROM MTL_SECONDARY_INVENTORIES

403:
404: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712
405: CURSOR validate_subinventory(C_ORGANIZATION_ID NUMBER, C_SUBINVENTORY VARCHAR2) IS
406: SELECT status_id
407: FROM MTL_SECONDARY_INVENTORIES
408: WHERE organization_id = C_ORGANIZATION_ID
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