Untitled
case when SEM_BOOLEAN_TO_CHAR(isOnBoradingRecord) = 'true' and bnpp_get_golden_source(FID_CountryRegistration, get_role_id(LP_RolesEnrichement), 'LP_Identification', get_source_definition_type_id(PublisherID)) = '1' then '100' when (SEM_BOOLEAN_TO_CHAR(isOnBoradingRecord) = 'false' or isOnBoradingRecord is null) and bnpp_get_golden_source(FID_CountryRegistration, get_role_id(LP_RolesEnrichement), 'LP_Identification', get_source_definition_type_id(PublisherID)) = '1' then '1' else bnpp_get_golden_source(FID_CountryRegistration, get_role_id(LP_RolesEnrichement), 'LP_Identification', get_source_definition_type_id(PublisherID)) end
Leave a Comment