HWM_TM_ATRB_FLDS

Details

Schema: FUSION
Object owner: HXT
Object type: VIEW

Columns

Name
TM_ATRB_FLD_ID OBJECT_VERSION_NUMBER ENTERPRISE_ID MODULE_ID TCSMRS_ID NAME CLASS PARENT_TM_ATRB_FLD_ID GLOBAL_TM_ATRB_FLD_ID VALUE_LOCATION ATTRIBUTE_CATEGORY ALLOWED_SCOPE MANDATORY_FOR_TCSMRS DISPLAY_NAME DESCRIPTION ATTRIBUTE_TYPE ATTRIBUTE_GROUP VALUE_SET_ID COMP_DISP_CODE BASE_UNIT UOM_TYPE UOM_BEHAVIOR UOM_UNIT UOM_CODE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY SGUID STORAGE_TYPE

Name

TM_ATRB_FLD_ID

OBJECT_VERSION_NUMBER

ENTERPRISE_ID

MODULE_ID

TCSMRS_ID

NAME

CLASS

PARENT_TM_ATRB_FLD_ID

GLOBAL_TM_ATRB_FLD_ID

VALUE_LOCATION

ATTRIBUTE_CATEGORY

ALLOWED_SCOPE

MANDATORY_FOR_TCSMRS

DISPLAY_NAME

DESCRIPTION

ATTRIBUTE_TYPE

ATTRIBUTE_GROUP

VALUE_SET_ID

COMP_DISP_CODE

BASE_UNIT

UOM_TYPE

UOM_BEHAVIOR

UOM_UNIT

UOM_CODE

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

SGUID

STORAGE_TYPE

Query

SQL_Statement
SELECT HWM_TM_ATRB_FLDS_B.TM_ATRB_FLD_ID TM_ATRB_FLD_ID, HWM_TM_ATRB_FLDS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HWM_TM_ATRB_FLDS_B.ENTERPRISE_ID ENTERPRISE_ID, HWM_TM_ATRB_FLDS_B.MODULE_ID MODULE_ID, HWM_TM_ATRB_FLDS_B.TCSMRS_ID TCSMRS_ID, HWM_TM_ATRB_FLDS_B.NAME NAME, HWM_TM_ATRB_FLDS_B.CLASS CLASS, HWM_TM_ATRB_FLDS_B.PARENT_TM_ATRB_FLD_ID PARENT_TM_ATRB_FLD_ID, HWM_TM_ATRB_FLDS_B.GLOBAL_TM_ATRB_FLD_ID GLOBAL_TM_ATRB_FLD_ID, HWM_TM_ATRB_FLDS_B.VALUE_LOCATION VALUE_LOCATION, HWM_TM_ATRB_FLDS_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, HWM_TM_ATRB_FLDS_B.ALLOWED_SCOPE ALLOWED_SCOPE, HWM_TM_ATRB_FLDS_B.MANDATORY_FOR_TCSMRS MANDATORY_FOR_TCSMRS, HWM_TM_ATRB_FLDS_TL.DISPLAY_NAME DISPLAY_NAME, HWM_TM_ATRB_FLDS_TL.DESCRIPTION DESCRIPTION, HWM_TM_ATRB_FLDS_B.ATTRIBUTE_TYPE ATTRIBUTE_TYPE, HWM_TM_ATRB_FLDS_B.ATTRIBUTE_GROUP ATTRIBUTE_GROUP, HWM_TM_ATRB_FLDS_B.VALUE_SET_ID VALUE_SET_ID, HWM_TM_ATRB_FLDS_B.COMP_DISP_CODE COMP_DISP_CODE, HWM_TM_ATRB_FLDS_B.BASE_UNIT, HWM_TM_ATRB_FLDS_B.UOM_TYPE, HWM_TM_ATRB_FLDS_B.UOM_BEHAVIOR, HWM_TM_ATRB_FLDS_B.UOM_UNIT, HWM_TM_ATRB_FLDS_B.UOM_CODE, HWM_TM_ATRB_FLDS_B.CREATED_BY CREATED_BY, HWM_TM_ATRB_FLDS_B.CREATION_DATE CREATION_DATE, HWM_TM_ATRB_FLDS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, HWM_TM_ATRB_FLDS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HWM_TM_ATRB_FLDS_B.LAST_UPDATED_BY LAST_UPDATED_BY, HWM_TM_ATRB_FLDS_B.SGUID SGUID, HWM_TM_ATRB_FLDS_B.STORAGE_TYPE FROM HWM_TM_ATRB_FLDS_B, HWM_TM_ATRB_FLDS_TL WHERE HWM_TM_ATRB_FLDS_B.TM_ATRB_FLD_ID = HWM_TM_ATRB_FLDS_TL.TM_ATRB_FLD_ID AND HWM_TM_ATRB_FLDS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

HWM_TM_ATRB_FLDS_B.TM_ATRB_FLD_ID TM_ATRB_FLD_ID,

HWM_TM_ATRB_FLDS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

HWM_TM_ATRB_FLDS_B.ENTERPRISE_ID ENTERPRISE_ID,

HWM_TM_ATRB_FLDS_B.MODULE_ID MODULE_ID,

HWM_TM_ATRB_FLDS_B.TCSMRS_ID TCSMRS_ID,

HWM_TM_ATRB_FLDS_B.NAME NAME,

HWM_TM_ATRB_FLDS_B.CLASS CLASS,

HWM_TM_ATRB_FLDS_B.PARENT_TM_ATRB_FLD_ID PARENT_TM_ATRB_FLD_ID,

HWM_TM_ATRB_FLDS_B.GLOBAL_TM_ATRB_FLD_ID GLOBAL_TM_ATRB_FLD_ID,

HWM_TM_ATRB_FLDS_B.VALUE_LOCATION VALUE_LOCATION,

HWM_TM_ATRB_FLDS_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

HWM_TM_ATRB_FLDS_B.ALLOWED_SCOPE ALLOWED_SCOPE,

HWM_TM_ATRB_FLDS_B.MANDATORY_FOR_TCSMRS MANDATORY_FOR_TCSMRS,

HWM_TM_ATRB_FLDS_TL.DISPLAY_NAME DISPLAY_NAME,

HWM_TM_ATRB_FLDS_TL.DESCRIPTION DESCRIPTION,

HWM_TM_ATRB_FLDS_B.ATTRIBUTE_TYPE ATTRIBUTE_TYPE,

HWM_TM_ATRB_FLDS_B.ATTRIBUTE_GROUP ATTRIBUTE_GROUP,

HWM_TM_ATRB_FLDS_B.VALUE_SET_ID VALUE_SET_ID,

HWM_TM_ATRB_FLDS_B.COMP_DISP_CODE COMP_DISP_CODE,

HWM_TM_ATRB_FLDS_B.BASE_UNIT,

HWM_TM_ATRB_FLDS_B.UOM_TYPE,

HWM_TM_ATRB_FLDS_B.UOM_BEHAVIOR,

HWM_TM_ATRB_FLDS_B.UOM_UNIT,

HWM_TM_ATRB_FLDS_B.UOM_CODE,

HWM_TM_ATRB_FLDS_B.CREATED_BY CREATED_BY,

HWM_TM_ATRB_FLDS_B.CREATION_DATE CREATION_DATE,

HWM_TM_ATRB_FLDS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

HWM_TM_ATRB_FLDS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

HWM_TM_ATRB_FLDS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

HWM_TM_ATRB_FLDS_B.SGUID SGUID,

HWM_TM_ATRB_FLDS_B.STORAGE_TYPE

FROM

HWM_TM_ATRB_FLDS_B,

HWM_TM_ATRB_FLDS_TL

WHERE

HWM_TM_ATRB_FLDS_B.TM_ATRB_FLD_ID = HWM_TM_ATRB_FLDS_TL.TM_ATRB_FLD_ID AND HWM_TM_ATRB_FLDS_TL.LANGUAGE = USERENV('LANG')