BDNA Data Platform 5.4 July 2017 (SQL Server) CAT_SW_LIC_RELEASE - The list of software product/release with all software license attributes attached to them
|
View Definition:
CREATE VIEW CAT_SW_LIC_RELEASE AS SELECT vw.CAT_SW_LIC_RELEASE_ID, vw.CREATE_DATE, vw.LAST_MODIFIED_DATE, vw.CAT_MANUFACTURER_ID, vw.CAT_SW_PRODUCT_ID, vw.CAT_SW_EDITION_ID, vw.CAT_SW_VERSION_GROUP_ID, vw.CAT_SW_VERSION_ID, vw.CAT_SW_RELEASE_ID, vw.CAT_PLATFORMS_ID, prod_tax.CAT_TAXONOMY2012_ID, vw.VENDOR_PRODUCT_NAME, vw.VENDOR_UNIT_OF_MEASURE, vw.LICENSE_TYPES, vw.LICENSE_TYPES_ID, vw.LICENSE_TYPES_OTHER, vw.LICENSE_METRICS, vw.LICENSE_METRICS_ID, vw.UNIT_PACK, vw.UNIT_COUNT_MIN, vw.UNIT_COUNT_MAX, vw.LICENSE_TERM, vw.LICENSE_INFORMATION_OTHER, vw.PERIOD_VALUE, vw.PERIOD_UNIT, vw.MAINT_PEROID_VALUE, vw.MAINT_PERIOD_VALUE, vw.MAINT_PEROID_UNIT, vw.MAINT_PERIOD_UNIT, vw.ENVIRONMENTS, vw.ENVIRONMENTS_ID, vw.ENVIRONMENTS_OTHER, vw.DOWNGRADE_VERSION_AUTH, vw.DOWNGRADE_VERSION_INCR, vw.DOWNGRADE_EDITION_AUTH, vw.DOWNGRADE_EDITION_INCR, vw.DOWNGRADE_DATE_MONTHS_MIN, vw.DOWNGRADE_DATE_MONTHS_MAX, vw.UPGRADE_VERSION_AUTH, vw.UPGRADE_VERSION_INCR, vw.UPGRADE_EDITION_AUTH, vw.UPGRADE_EDITION_INCR, vw.UPGRADE_DATE_MONTHS_MIN, vw.UPGRADE_DATE_MONTHS_MAX, vw.DUAL_LICENSE_AUTH, vw.VIRTUAL_INSTALL_AUTH, vw.VIRTUAL_INSTALL_MAX, vw.REASSIGNMENT_AUTH, vw.CROSS_LANGUAGE_AUTH, vw.CROSS_PLATFORMS_AUTH, vw.CORE_FACTOR, vw.LANGUAGES, vw.LANGUAGES_ID, vw.MAINTENANCE_GRADES, vw.MAINTENANCE_GRADES_ID, vw.DISTRIBUTION_MEDIAS, vw.DISTRIBUTION_MEDIAS_ID, vw.PROGRAMS, vw.PROGRAMS_ID, vw.PRICINGS, vw.PRICINGS_ID, vw.PRICE_LEVELS, vw.PRICE_LEVELS_ID, vw.CAT_SW_LIC_PRODUCT_ID, vw.REQ_SPECIFIC_VERSION, vw.LIC_PRODUCT_LONG_DESC, vw.INST_GUIDE_URL, vw.CUTSHEET_URL, vw.PICTURE_URL, vw.TO_BE_DELETED, vw.TO_BE_DELETED_ON, vw.DELETE_REASON, vw.PRIVATE_FLAG, vw.IS_PRIVATE, vw.PRIVATE_TYPE, vw.REPLACEMENT_ID FROM ( SELECT f_tcat.CAT_SW_LIC_RELEASE_ID,f_tcat.CREATE_DATE,f_tcat.LAST_MODIFIED_DATE,f_tcat.CAT_MANUFACTURER_ID,f_tcat.CAT_SW_PRODUCT_ID,f_tcat.CAT_SW_EDITION_ID,f_tcat.CAT_SW_VERSION_GROUP_ID,f_tcat.CAT_SW_VERSION_ID,f_tcat.CAT_SW_RELEASE_ID,f_tcat.CAT_PLATFORMS_ID,f_tcat.CAT_TAXONOMY2012_ID,f_tcat.VENDOR_PRODUCT_NAME,f_tcat.VENDOR_UNIT_OF_MEASURE,f_tcat.LICENSE_TYPES,f_tcat.LICENSE_TYPES_ID,f_tcat.LICENSE_TYPES_OTHER,f_tcat.LICENSE_METRICS,f_tcat.LICENSE_METRICS_ID,f_tcat.UNIT_PACK,f_tcat.UNIT_COUNT_MIN,f_tcat.UNIT_COUNT_MAX,f_tcat.LICENSE_TERM,f_tcat.LICENSE_INFORMATION_OTHER,f_tcat.PERIOD_VALUE,f_tcat.PERIOD_UNIT,f_tcat.MAINT_PEROID_VALUE,f_tcat.MAINT_PERIOD_VALUE,f_tcat.MAINT_PEROID_UNIT,f_tcat.MAINT_PERIOD_UNIT,f_tcat.ENVIRONMENTS,f_tcat.ENVIRONMENTS_ID,f_tcat.ENVIRONMENTS_OTHER,f_tcat.DOWNGRADE_VERSION_AUTH,f_tcat.DOWNGRADE_VERSION_INCR,f_tcat.DOWNGRADE_EDITION_AUTH,f_tcat.DOWNGRADE_EDITION_INCR,f_tcat.DOWNGRADE_DATE_MONTHS_MIN,f_tcat.DOWNGRADE_DATE_MONTHS_MAX,f_tcat.UPGRADE_VERSION_AUTH,f_tcat.UPGRADE_VERSION_INCR,f_tcat.UPGRADE_EDITION_AUTH,f_tcat.UPGRADE_EDITION_INCR,f_tcat.UPGRADE_DATE_MONTHS_MIN,f_tcat.UPGRADE_DATE_MONTHS_MAX,f_tcat.DUAL_LICENSE_AUTH,f_tcat.VIRTUAL_INSTALL_AUTH,f_tcat.VIRTUAL_INSTALL_MAX,f_tcat.REASSIGNMENT_AUTH,f_tcat.CROSS_LANGUAGE_AUTH,f_tcat.CROSS_PLATFORMS_AUTH,f_tcat.CORE_FACTOR,f_tcat.LANGUAGES,f_tcat.LANGUAGES_ID,f_tcat.MAINTENANCE_GRADES,f_tcat.MAINTENANCE_GRADES_ID,f_tcat.DISTRIBUTION_MEDIAS,f_tcat.DISTRIBUTION_MEDIAS_ID,f_tcat.PROGRAMS,f_tcat.PROGRAMS_ID,f_tcat.PRICINGS,f_tcat.PRICINGS_ID,f_tcat.PRICE_LEVELS,f_tcat.PRICE_LEVELS_ID,f_tcat.CAT_SW_LIC_PRODUCT_ID,f_tcat.REQ_SPECIFIC_VERSION,f_tcat.LIC_PRODUCT_LONG_DESC,f_tcat.INST_GUIDE_URL,f_tcat.CUTSHEET_URL,f_tcat.PICTURE_URL,f_tcat.TO_BE_DELETED,f_tcat.TO_BE_DELETED_ON,f_tcat.DELETE_REASON,f_tcat.PRIVATE_FLAG,f_tcat.IS_PRIVATE,f_tcat.PRIVATE_TYPE,f_tcat.REPLACEMENT_ID from TCAT_SW_LIC_RELEASE f_tcat where not exists (select 1 from TPC_SW_LIC_RELEASE tpc_tab where tpc_tab.CAT_SW_LIC_RELEASE_ID=f_tcat.CAT_SW_LIC_RELEASE_ID ) union all SELECT * FROM ( SELECT COALESCE(tpc.CAT_SW_LIC_RELEASE_ID,tcat.CAT_SW_LIC_RELEASE_ID) CAT_SW_LIC_RELEASE_ID,COALESCE(tpc.CREATE_DATE,tcat.CREATE_DATE) CREATE_DATE,CASE WHEN ISNULL(tpc.LAST_MODIFIED_DATE,'31-DEC-1900') > tcat.LAST_MODIFIED_D
Possibly Referenced Tables/Views: