APPS.CS_SR_PROB_CODE_MAPPING_PKG dependencies on MTL_ITEM_CATEGORIES

Line 111: exists (select category_id from mtl_item_categories cmtlc

107: cstl.category_id is null)
108: or
109: (cstl.incident_type_id = l_service_request_type_id and
110: cstl.inventory_item_id is null and
111: exists (select category_id from mtl_item_categories cmtlc
112: where
113: cmtlc.category_id = cstl.category_id and
114: category_set_id = l_category_set_id and
115: cmtlc.inventory_item_id = l_inventory_item_id and

Line 148: exists (select category_id from mtl_item_categories cmtlc

144: cstl.category_id is null)
145: or
146: (cstl.incident_type_id is null and
147: cstl.inventory_item_id is null and
148: exists (select category_id from mtl_item_categories cmtlc
149: where
150: cmtlc.category_id = cstl.category_id and
151: category_set_id = l_category_set_id and /* value from profile CS_SR_DEFAULT_CATEGORY_SET */
152: cmtlc.inventory_item_id = l_inventory_item_id and