BDNA Data Platform 5.4 July 2017 (Oracle) CAT_HW_LIC_CHARACTERISTICS - A table containing all relevant characteristic of the hardware model that is specified in the hardware license
|
View Definition:
SELECT f_tcat.CAT_HW_LIC_CHARACTERISTICS_ID,f_tcat.CREATE_DATE,f_tcat.LAST_MODIFIED_DATE,f_tcat.MEMORY_MAX,f_tcat.MEMORY_MAX_UNIT,f_tcat.MEMORY_SPECIFICATION,f_tcat.MEMORY_TECHNOLOGY,f_tcat.MEMORY_SPEED,f_tcat.MEMORY_STORAGE_CAPACITY,f_tcat.MEMORY_STORAGE_UNIT,f_tcat.HARDDRIVE_INTERFACE,f_tcat.NETWORK_TYPE,f_tcat.DATA_LINK_PROTOCOL,f_tcat.OPTICAL_DRIVE,f_tcat.GRAPHICS_CARD,f_tcat.INTERFACE_PORTS,f_tcat.MONITOR_RESOLUTION_LENGTH,f_tcat.MONITOR_RESOLUTION_WIDTH,f_tcat.PROCESSOR_TYPE,f_tcat.PROCESSOR_SPEED,f_tcat.PROCESSOR_INSTALLED_QTY,f_tcat.PROCESSOR_MAX_SUPPORTED,f_tcat.INSTALLED_RAM,f_tcat.INSTALLED_RAM_UNIT,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_HW_LIC_CHARACTERISTICS f_tcat where not exists (select 1 from TPC_HW_LIC_CHARACTERISTICS tpc_tab where tpc_tab.CAT_HW_LIC_CHARACTERISTICS_ID=f_tcat.CAT_HW_LIC_CHARACTERISTICS_ID ) union all SELECT "CAT_HW_LIC_CHARACTERISTICS_ID","CREATE_DATE","LAST_MODIFIED_DATE","MEMORY_MAX","MEMORY_MAX_UNIT","MEMORY_SPECIFICATION","MEMORY_TECHNOLOGY","MEMORY_SPEED","MEMORY_STORAGE_CAPACITY","MEMORY_STORAGE_UNIT","HARDDRIVE_INTERFACE","NETWORK_TYPE","DATA_LINK_PROTOCOL","OPTICAL_DRIVE","GRAPHICS_CARD","INTERFACE_PORTS","MONITOR_RESOLUTION_LENGTH","MONITOR_RESOLUTION_WIDTH","PROCESSOR_TYPE","PROCESSOR_SPEED","PROCESSOR_INSTALLED_QTY","PROCESSOR_MAX_SUPPORTED","INSTALLED_RAM","INSTALLED_RAM_UNIT","TO_BE_DELETED","TO_BE_DELETED_ON","DELETE_REASON","PRIVATE_FLAG","IS_PRIVATE","PRIVATE_TYPE","REPLACEMENT_ID" FROM ( SELECT COALESCE(tpc.CAT_HW_LIC_CHARACTERISTICS_ID,tcat.CAT_HW_LIC_CHARACTERISTICS_ID) CAT_HW_LIC_CHARACTERISTICS_ID,COALESCE(tpc.CREATE_DATE,tcat.CREATE_DATE) CREATE_DATE,GREATEST(NVL(tpc.LAST_MODIFIED_DATE,TO_DATE('31-DEC-1900','DD-MON-YYYY')),tcat.LAST_MODIFIED_DATE) LAST_MODIFIED_DATE,COALESCE(tpc.MEMORY_MAX,tcat.MEMORY_MAX) MEMORY_MAX,COALESCE(tpc.MEMORY_MAX_UNIT,tcat.MEMORY_MAX_UNIT) MEMORY_MAX_UNIT,COALESCE(tpc.MEMORY_SPECIFICATION,tcat.MEMORY_SPECIFICATION) MEMORY_SPECIFICATION,COALESCE(tpc.MEMORY_TECHNOLOGY,tcat.MEMORY_TECHNOLOGY) MEMORY_TECHNOLOGY,COALESCE(tpc.MEMORY_SPEED,tcat.MEMORY_SPEED) MEMORY_SPEED,COALESCE(tpc.MEMORY_STORAGE_CAPACITY,tcat.MEMORY_STORAGE_CAPACITY) MEMORY_STORAGE_CAPACITY,COALESCE(tpc.MEMORY_STORAGE_UNIT,tcat.MEMORY_STORAGE_UNIT) MEMORY_STORAGE_UNIT,COALESCE(tpc.HARDDRIVE_INTERFACE,tcat.HARDDRIVE_INTERFACE) HARDDRIVE_INTERFACE,COALESCE(tpc.NETWORK_TYPE,tcat.NETWORK_TYPE) NETWORK_TYPE,COALESCE(tpc.DATA_LINK_PROTOCOL,tcat.DATA_LINK_PROTOCOL) DATA_LINK_PROTOCOL,COALESCE(tpc.OPTICAL_DRIVE,tcat.OPTICAL_DRIVE) OPTICAL_DRIVE,COALESCE(tpc.GRAPHICS_CARD,tcat.GRAPHICS_CARD) GRAPHICS_CARD,COALESCE(tpc.INTERFACE_PORTS,tcat.INTERFACE_PORTS) INTERFACE_PORTS,COALESCE(tpc.MONITOR_RESOLUTION_LENGTH,tcat.MONITOR_RESOLUTION_LENGTH) MONITOR_RESOLUTION_LENGTH,COALESCE(tpc.MONITOR_RESOLUTION_WIDTH,tcat.MONITOR_RESOLUTION_WIDTH) MONITOR_RESOLUTION_WIDTH,COALESCE(tpc.PROCESSOR_TYPE,tcat.PROCESSOR_TYPE) PROCESSOR_TYPE,COALESCE(tpc.PROCESSOR_SPEED,tcat.PROCESSOR_SPEED) PROCESSOR_SPEED,COALESCE(tpc.PROCESSOR_INSTALLED_QTY,tcat.PROCESSOR_INSTALLED_QTY) PROCESSOR_INSTALLED_QTY,COALESCE(tpc.PROCESSOR_MAX_SUPPORTED,tcat.PROCESSOR_MAX_SUPPORTED) PROCESSOR_MAX_SUPPORTED,COALESCE(tpc.INSTALLED_RAM,tcat.INSTALLED_RAM) INSTALLED_RAM,COALESCE(tpc.INSTALLED_RAM_UNIT,tcat.INSTALLED_RAM_UNIT) INSTALLED_RAM_UNIT,COALESCE(tpc.TO_BE_DELETED,tcat.TO_BE_DELETED) TO_BE_DELETED,COALESCE(tpc.TO_BE_DELETED_ON,tcat.TO_BE_DELETED_ON) TO_BE_DELETED_ON,COALESCE(tpc.DELETE_REASON,tcat.DELETE_REASON) DELETE_REASON,COALESCE(uuid.PRIVATE_FLAG,tcat.PRIVATE_FLAG) PRIVATE_FLAG, COALESCE(uuid.IS_PRIVATE,tcat.IS_PRIVATE) IS_PRIVATE, COALESCE(uuid.PRIVATE_TYPE,tcat.PRIVATE_TYPE) PRIVATE_TYPE, COALESCE(tpc.REPLACEMENT_ID,tcat.REPLACEMENT_ID) REPLACEMENT_ID FROM TPC_HW_LIC_CHARACTERISTICS tpc LEFT JOIN TCAT_HW_LIC_CHARACTERISTICS tcat ON tcat.CAT_HW_LIC_CHARACTERISTICS_ID = tpc.CAT_HW_LIC_CHARACTERISTICS_ID inner JOIN TPC_UUID uuid ON tpc.CAT_HW_LIC_CHARACTERISTICS_ID = uuid.CAT_UUID_ID AND SIGN(tpc.CAT_HW_LIC_CHARACTERISTICS_ID )!= -1 ) cat_tab UNION ALL SELECT tpc.CAT_HW_LIC_CHARACTERISTICS_ID,tpc.CREATE_DATE,tpc.LAST_MODIFIED_DATE,tpc.MEMORY_MAX,tpc.MEMORY_MAX_UNIT,tpc.MEMORY_SPECIFICATION,tpc.MEMORY_TECHNOLOGY,tpc.MEMORY_SPEED,tpc.MEMORY_STORAGE_CAPACITY,tpc.MEMORY_STORAGE_UNIT,tpc.HARDDRIVE_INTERFACE,tpc.NETWORK_TYPE,tpc.DATA_LINK_PROTOCOL,tpc.OPTICAL_DRIVE,tpc.GRAPHICS_CARD,tpc.INTERFACE_PORTS,tpc.MONITOR_RESOLUTION_LENGTH,tpc.MONITOR_RESOLUTION_WIDTH,tpc.PROCESSOR_TYPE,tpc.PROCESSOR_SPEED,tpc.PROCESSOR_INSTALLED_QTY,tpc.PROCESSOR_MAX_SUPPORTED,tpc.INSTALLED_RAM,tpc.INSTALLED_RAM_UNIT,tpc.TO_BE_DELETED,tpc.TO_BE_DELETED_ON,tpc.DELETE_REASON,tpc.PRIVATE_FLAG,tpc.IS_PRIVATE,tpc.PRIVATE_TYPE,tpc.REPLACEMENT_ID FROM TPC_HW_LIC_CHARACTERISTICS tpc WHERE SIGN(tpc.CAT_HW_LIC_CHARACTERISTICS_ID )= -1