DBA Data[Home] [Help]

APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_EFFECTIVITIES_VL

Line 1505: FROM AHL_UNIT_EFFECTIVITIES_VL

1501: -- For preventive maintenance bug# 4692366, changing logic to base
1502: -- on min unit_effectivity_id as duplicate forecast seq can exist if
1503: -- contract numbers are different(renewal, modification cases).
1504: SELECT MIN(unit_effectivity_id)
1505: FROM AHL_UNIT_EFFECTIVITIES_VL
1506: WHERE MR_HEADER_ID = p_mr_id AND
1507: CSI_ITEM_INSTANCE_ID = p_item_instance_id AND
1508: service_line_id = p_service_line_id AND
1509: (STATUS_CODE IS NULL OR