project BLF > class BSODCategoryExclusion > business logic query CategoriesAreInConflict
Parameters
iiCategory1ID | integer | |
iiCategory2ID | integer | |
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 name | data type | db field | description |
tiSODCategory1_ID | integer | SODExclusion.SODCategory1_ID | link to SOD Category 1 |
tiSODCategory2_ID | integer | SODExclusion.SODCategory2_ID | link to SOD Category 2 |
tcSODCategoryCode1 | character | SODCategory1.SODCategoryCode | SOD category code |
tcSODCategoryCode2 | character | SODCategory2.SODCategoryCode | SOD category code |
tcSODExclusionLevel | character | SODExclusion.SODExclusionLevel | Exclusion Level |
Internal usage
BLF