BDNA Data Platform 5.4 July 2017 (Oracle) TECHNOPEDIA_TABS_METADATA_VW - Internal Technopedia view
|
View Definition:
SELECT TECH.TECHNOPEDIA_TABS_METADATA_ID,
TECH.OWNER,
TECH.TABLE_NAME,
TECH.COLUMN_NAME,
TECH.COLUMN_LABEL,
TECH.DATA_TYPE,
TECH.DATA_LENGTH,
TECH.DATA_PRECISION,
TECH.NULLABLE,
TECH.DATA_DEFAULT,
TECH.TABLE_ORDER,
TECH.COLUMN_ORDER,
COALESCE(TECHNOPEDIA_UI_META.DISPLAY_ORDER,TECH.DISPLAY_ORDER) DISPLAY_ORDER,
COALESCE(TECHNOPEDIA_UI_META.IS_IN_DEFAULT_VIEW,TECH.IS_IN_DEFAULT_VIEW) IS_IN_DEFAULT_VIEW,
TECH.ACTIVE,
TECH.VERSION,
TECH.COMMENTS,
TECH.IS_VISIBLE,
TECH.IS_PRIVATE,
TECH.SECTION,
TECH.ISEDITABLE,
TECH.ISREQUIRED
FROM (
select TECHNOPEDIA_TABS_METADATA_ID,
TO_NCHAR(OWNER) OWNER,
TO_NCHAR(case when substr(TABLE_NAME,1,4) ='TCAT'
then substr(TABLE_NAME,2,length(TABLE_NAME)) else TABLE_NAME end) TABLE_NAME,
TO_NCHAR(COLUMN_NAME) COLUMN_NAME,
TO_NCHAR(DISPLAY_LABEL) AS COLUMN_LABEL,
TO_NCHAR(DATA_TYPE) DATA_TYPE,
DATA_LENGTH,
DATA_PRECISION,
TO_NCHAR(NULLABLE) NULLABLE,
TO_NCHAR(DATA_DEFAULT) DATA_DEFAULT,
TABLE_ORDER,
COLUMN_ORDER,
DISPLAY_ORDER AS DISPLAY_ORDER,
TO_NCHAR(IS_IN_DEFAULT_VIEW) IS_IN_DEFAULT_VIEW,
TO_NCHAR(ACTIVE) ACTIVE,
TO_NCHAR(VERSION) VERSION,
COMMENTS,
TO_NCHAR(IS_VISIBLE) IS_VISIBLE,
'N' IS_PRIVATE,
SECTION,
ISEDITABLE,
ISREQUIRED
FROM TECHNOPEDIA_TABS_METADATA
UNION
SELECT TPC_TABS_METADATA_ID,
OWNER,
TABLE_NAME,
COLUMN_NAME,
DISPLAY_LABEL AS COLUMN_LABEL,
DATA_TYPE,
DATA_LENGTH,
DATA_PRECISION,
NULLABLE,
DATA_DEFAULT,
TABLE_ORDER,
COLUMN_ORDER,
DISPLAY_ORDER,
IS_IN_DEFAULT_VIEW,
ACTIVE,
VERSION,
COMMENTS,
IS_VISIBLE,
'Y' IS_PRIVATE,
SECTION,
ISEDITABLE,
ISREQUIRED
FROM TPC_TABS_METADATA
) TECH LEFT JOIN TECHNOPEDIA_UI_META ON TECHNOPEDIA_UI_META.TECHNOPEDIA_TABS_METADATA_ID = TECH.TECHNOPEDIA_TABS_METADATA_ID
Possibly Referenced Tables/Views: