Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
700 B
2
Indexable
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