DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_EFFECTIVITIES_VL

Line 1325: FROM AHL_UNIT_EFFECTIVITIES_VL

1321: -- For preventive maintenance bug# 4692366, changing logic to base
1322: -- on min unit_effectivity_id as duplicate forecast seq can exist if
1323: -- contract numbers are different(renewal, modification cases).
1324: SELECT MIN(unit_effectivity_id)
1325: FROM AHL_UNIT_EFFECTIVITIES_VL
1326: WHERE MR_HEADER_ID = p_mr_id AND
1327: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
1328: service_line_id = p_service_line_id AND
1329: (STATUS_CODE IS NULL OR