HWM_TM_ATRB_FLD_USAGES

Details

Schema: FUSION
Object owner: HWM
Object type: VIEW

Columns

Name
TM_ATRB_FLD_USAGE_ID TM_ATRB_FLD_CONTEXT_ID TM_ATRB_FLD_ID NAME DISPLAY_NAME DESCRIPTION USER_DATA_SOURCE_USAGE_ID ADMIN_DATA_SOURCE_USAGE_ID ENTERPRISE_ID MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY SGUID TM_ATRB_FLD_CODE CXT_CODE

Name

TM_ATRB_FLD_USAGE_ID

TM_ATRB_FLD_CONTEXT_ID

TM_ATRB_FLD_ID

NAME

DISPLAY_NAME

DESCRIPTION

USER_DATA_SOURCE_USAGE_ID

ADMIN_DATA_SOURCE_USAGE_ID

ENTERPRISE_ID

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

SGUID

TM_ATRB_FLD_CODE

CXT_CODE

Query

SQL_Statement
SELECT HWM_TM_ATRB_FLD_USAGES_B.TM_ATRB_FLD_USAGE_ID TM_ATRB_FLD_USAGE_ID, HWM_TM_ATRB_FLD_USAGES_B.TM_ATRB_FLD_CONTEXT_ID TM_ATRB_FLD_CONTEXT_ID, HWM_TM_ATRB_FLD_USAGES_B.TM_ATRB_FLD_ID TM_ATRB_FLD_ID, HWM_TM_ATRB_FLD_USAGES_B.NAME NAME, HWM_TM_ATRB_FLD_USAGES_TL.DISPLAY_NAME DISPLAY_NAME, HWM_TM_ATRB_FLD_USAGES_TL.DESCRIPTION DESCRIPTION, HWM_TM_ATRB_FLD_USAGES_B.USER_DATA_SOURCE_USAGE_ID USER_DATA_SOURCE_USAGE_ID, HWM_TM_ATRB_FLD_USAGES_B.ADMIN_DATA_SOURCE_USAGE_ID ADMIN_DATA_SOURCE_USAGE_ID, HWM_TM_ATRB_FLD_USAGES_B.ENTERPRISE_ID ENTERPRISE_ID, HWM_TM_ATRB_FLD_USAGES_B.MODULE_ID MODULE_ID, HWM_TM_ATRB_FLD_USAGES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HWM_TM_ATRB_FLD_USAGES_B.CREATED_BY CREATED_BY, HWM_TM_ATRB_FLD_USAGES_B.CREATION_DATE CREATION_DATE, HWM_TM_ATRB_FLD_USAGES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, HWM_TM_ATRB_FLD_USAGES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HWM_TM_ATRB_FLD_USAGES_B.LAST_UPDATED_BY LAST_UPDATED_BY, HWM_TM_ATRB_FLD_USAGES_B.SGUID, HWM_TM_ATRB_FLD_USAGES_B.TM_ATRB_FLD_CODE, HWM_TM_ATRB_FLD_USAGES_B.CXT_CODE FROM HWM_TM_ATRB_FLD_USAGES_B, HWM_TM_ATRB_FLD_USAGES_TL WHERE HWM_TM_ATRB_FLD_USAGES_B.TM_ATRB_FLD_USAGE_ID = HWM_TM_ATRB_FLD_USAGES_TL.TM_ATRB_FLD_USAGE_ID AND HWM_TM_ATRB_FLD_USAGES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

HWM_TM_ATRB_FLD_USAGES_B.TM_ATRB_FLD_USAGE_ID TM_ATRB_FLD_USAGE_ID,

HWM_TM_ATRB_FLD_USAGES_B.TM_ATRB_FLD_CONTEXT_ID TM_ATRB_FLD_CONTEXT_ID,

HWM_TM_ATRB_FLD_USAGES_B.TM_ATRB_FLD_ID TM_ATRB_FLD_ID,

HWM_TM_ATRB_FLD_USAGES_B.NAME NAME,

HWM_TM_ATRB_FLD_USAGES_TL.DISPLAY_NAME DISPLAY_NAME,

HWM_TM_ATRB_FLD_USAGES_TL.DESCRIPTION DESCRIPTION,

HWM_TM_ATRB_FLD_USAGES_B.USER_DATA_SOURCE_USAGE_ID USER_DATA_SOURCE_USAGE_ID,

HWM_TM_ATRB_FLD_USAGES_B.ADMIN_DATA_SOURCE_USAGE_ID ADMIN_DATA_SOURCE_USAGE_ID,

HWM_TM_ATRB_FLD_USAGES_B.ENTERPRISE_ID ENTERPRISE_ID,

HWM_TM_ATRB_FLD_USAGES_B.MODULE_ID MODULE_ID,

HWM_TM_ATRB_FLD_USAGES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

HWM_TM_ATRB_FLD_USAGES_B.CREATED_BY CREATED_BY,

HWM_TM_ATRB_FLD_USAGES_B.CREATION_DATE CREATION_DATE,

HWM_TM_ATRB_FLD_USAGES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

HWM_TM_ATRB_FLD_USAGES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

HWM_TM_ATRB_FLD_USAGES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

HWM_TM_ATRB_FLD_USAGES_B.SGUID,

HWM_TM_ATRB_FLD_USAGES_B.TM_ATRB_FLD_CODE,

HWM_TM_ATRB_FLD_USAGES_B.CXT_CODE

FROM

HWM_TM_ATRB_FLD_USAGES_B,

HWM_TM_ATRB_FLD_USAGES_TL

WHERE

HWM_TM_ATRB_FLD_USAGES_B.TM_ATRB_FLD_USAGE_ID = HWM_TM_ATRB_FLD_USAGES_TL.TM_ATRB_FLD_USAGE_ID AND HWM_TM_ATRB_FLD_USAGES_TL.LANGUAGE = USERENV('LANG')