project BLF > class BSODCategoryExclusion > business logic query CategoriesAreInConflict


Parameters


iiCategory1IDinteger
iiCategory2IDinteger


query condition


  each SODExclusion where
SODExclusion.SODCategory1_ID = iiCategory1ID AND
SODExclusion.SODCategory2_ID = iiCategory2ID

      first SODCategory1 (inner-join) where
SODCategory1.SODCategory_ID = SODExclusion.SODCategory1_ID AND

      first SODCategory2 (inner-join) where
SODCategory2.SODCategory_ID = SODExclusion.SODCategory2_ID AND


query resultset tqCategoriesAreInConflict


field namedata typedb fielddescription
tiSODCategory1_IDintegerSODExclusion.SODCategory1_IDlink to SOD Category 1
tiSODCategory2_IDintegerSODExclusion.SODCategory2_IDlink to SOD Category 2
tcSODCategoryCode1characterSODCategory1.SODCategoryCodeSOD category code
tcSODCategoryCode2characterSODCategory2.SODCategoryCodeSOD category code
tcSODExclusionLevelcharacterSODExclusion.SODExclusionLevelExclusion Level


Internal usage


BLF
method BSODPolicyException.AdditionalUpdates
method BSystem.PostTransaction