HXT_TCLAYFLD_DEFNS

Details

Schema: FUSION
Object owner: HXT
Object type: VIEW

Columns

Name
TCLAYFLD_DEFNS_ID P_TCLAYFLD_DEFNS_ID TCLAYFLD_DEFNS_INSTANCE_FLAG TCLAYFLD_TMPL_ID OBJECT_VERSION_NUMBER ENTERPRISE_ID DISPLAY_SEQUENCE TCLAYFLD_ATTRIBUTE_CATEGORY TCLAYFLD_ATTRIBUTE_CHAR1 TCLAYFLD_ATTRIBUTE_CHAR2 TCLAYFLD_ATTRIBUTE_CHAR3 TCLAYFLD_ATTRIBUTE_CHAR4 TCLAYFLD_ATTRIBUTE_CHAR5 TCLAYFLD_ATTRIBUTE_CHAR6 TCLAYFLD_ATTRIBUTE_CHAR7 TCLAYFLD_ATTRIBUTE_CHAR8 TCLAYFLD_ATTRIBUTE_CHAR9 TCLAYFLD_ATTRIBUTE_CHAR10 TCLAYFLD_ATTRIBUTE_CHAR11 TCLAYFLD_ATTRIBUTE_CHAR12 TCLAYFLD_ATTRIBUTE_CHAR13 TCLAYFLD_ATTRIBUTE_CHAR14 TCLAYFLD_ATTRIBUTE_CHAR15 TCLAYFLD_ATTRIBUTE_CHAR16 TCLAYFLD_ATTRIBUTE_CHAR17 TCLAYFLD_ATTRIBUTE_CHAR18 TCLAYFLD_ATTRIBUTE_CHAR19 TCLAYFLD_ATTRIBUTE_CHAR20 TCLAYFLD_ATTRIBUTE_CHAR21 TCLAYFLD_ATTRIBUTE_CHAR22 TCLAYFLD_ATTRIBUTE_CHAR23 TCLAYFLD_ATTRIBUTE_CHAR24 TCLAYFLD_ATTRIBUTE_CHAR25 TCLAYFLD_ATTRIBUTE_CHAR26 TCLAYFLD_ATTRIBUTE_CHAR27 TCLAYFLD_ATTRIBUTE_CHAR28 TCLAYFLD_ATTRIBUTE_CHAR29 TCLAYFLD_ATTRIBUTE_CHAR30 TCLAYFLD_ATTRIBUTE_NUMBER1 TCLAYFLD_ATTRIBUTE_NUMBER2 TCLAYFLD_ATTRIBUTE_NUMBER3 TCLAYFLD_ATTRIBUTE_NUMBER4 TCLAYFLD_ATTRIBUTE_NUMBER5 TCLAYFLD_ATTRIBUTE_NUMBER6 TCLAYFLD_ATTRIBUTE_NUMBER7 TCLAYFLD_ATTRIBUTE_NUMBER8 TCLAYFLD_ATTRIBUTE_NUMBER9 TCLAYFLD_ATTRIBUTE_NUMBER10 TCLAYFLD_ATTRIBUTE_NUMBER11 TCLAYFLD_ATTRIBUTE_NUMBER12 TCLAYFLD_ATTRIBUTE_NUMBER13 TCLAYFLD_ATTRIBUTE_NUMBER14 TCLAYFLD_ATTRIBUTE_NUMBER15 TCLAYFLD_ATTRIBUTE_NUMBER16 TCLAYFLD_ATTRIBUTE_NUMBER17 TCLAYFLD_ATTRIBUTE_NUMBER18 TCLAYFLD_ATTRIBUTE_NUMBER19 TCLAYFLD_ATTRIBUTE_NUMBER20 TCLAYFLD_ATTRIBUTE_DATE1 TCLAYFLD_ATTRIBUTE_DATE2 TCLAYFLD_ATTRIBUTE_DATE3 TCLAYFLD_ATTRIBUTE_DATE4 TCLAYFLD_ATTRIBUTE_DATE5 TCLAYFLD_ATTRIBUTE_DATE6 TCLAYFLD_ATTRIBUTE_DATE7 TCLAYFLD_ATTRIBUTE_DATE8 TCLAYFLD_ATTRIBUTE_DATE9 TCLAYFLD_ATTRIBUTE_DATE10 TCLAYFLD_ATTRIBUTE_DATE11 TCLAYFLD_ATTRIBUTE_DATE12 TCLAYFLD_ATTRIBUTE_DATE13 TCLAYFLD_ATTRIBUTE_DATE14 TCLAYFLD_ATTRIBUTE_DATE15 CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY NAME DESCRIPTION LABEL MODULE_ID TCLAY_ID TCLAYFLD_DEFNS_CD SGUID

Name

TCLAYFLD_DEFNS_ID

P_TCLAYFLD_DEFNS_ID

TCLAYFLD_DEFNS_INSTANCE_FLAG

TCLAYFLD_TMPL_ID

OBJECT_VERSION_NUMBER

ENTERPRISE_ID

DISPLAY_SEQUENCE

TCLAYFLD_ATTRIBUTE_CATEGORY

TCLAYFLD_ATTRIBUTE_CHAR1

TCLAYFLD_ATTRIBUTE_CHAR2

TCLAYFLD_ATTRIBUTE_CHAR3

TCLAYFLD_ATTRIBUTE_CHAR4

TCLAYFLD_ATTRIBUTE_CHAR5

TCLAYFLD_ATTRIBUTE_CHAR6

TCLAYFLD_ATTRIBUTE_CHAR7

TCLAYFLD_ATTRIBUTE_CHAR8

TCLAYFLD_ATTRIBUTE_CHAR9

TCLAYFLD_ATTRIBUTE_CHAR10

TCLAYFLD_ATTRIBUTE_CHAR11

TCLAYFLD_ATTRIBUTE_CHAR12

TCLAYFLD_ATTRIBUTE_CHAR13

TCLAYFLD_ATTRIBUTE_CHAR14

TCLAYFLD_ATTRIBUTE_CHAR15

TCLAYFLD_ATTRIBUTE_CHAR16

TCLAYFLD_ATTRIBUTE_CHAR17

TCLAYFLD_ATTRIBUTE_CHAR18

TCLAYFLD_ATTRIBUTE_CHAR19

TCLAYFLD_ATTRIBUTE_CHAR20

TCLAYFLD_ATTRIBUTE_CHAR21

TCLAYFLD_ATTRIBUTE_CHAR22

TCLAYFLD_ATTRIBUTE_CHAR23

TCLAYFLD_ATTRIBUTE_CHAR24

TCLAYFLD_ATTRIBUTE_CHAR25

TCLAYFLD_ATTRIBUTE_CHAR26

TCLAYFLD_ATTRIBUTE_CHAR27

TCLAYFLD_ATTRIBUTE_CHAR28

TCLAYFLD_ATTRIBUTE_CHAR29

TCLAYFLD_ATTRIBUTE_CHAR30

TCLAYFLD_ATTRIBUTE_NUMBER1

TCLAYFLD_ATTRIBUTE_NUMBER2

TCLAYFLD_ATTRIBUTE_NUMBER3

TCLAYFLD_ATTRIBUTE_NUMBER4

TCLAYFLD_ATTRIBUTE_NUMBER5

TCLAYFLD_ATTRIBUTE_NUMBER6

TCLAYFLD_ATTRIBUTE_NUMBER7

TCLAYFLD_ATTRIBUTE_NUMBER8

TCLAYFLD_ATTRIBUTE_NUMBER9

TCLAYFLD_ATTRIBUTE_NUMBER10

TCLAYFLD_ATTRIBUTE_NUMBER11

TCLAYFLD_ATTRIBUTE_NUMBER12

TCLAYFLD_ATTRIBUTE_NUMBER13

TCLAYFLD_ATTRIBUTE_NUMBER14

TCLAYFLD_ATTRIBUTE_NUMBER15

TCLAYFLD_ATTRIBUTE_NUMBER16

TCLAYFLD_ATTRIBUTE_NUMBER17

TCLAYFLD_ATTRIBUTE_NUMBER18

TCLAYFLD_ATTRIBUTE_NUMBER19

TCLAYFLD_ATTRIBUTE_NUMBER20

TCLAYFLD_ATTRIBUTE_DATE1

TCLAYFLD_ATTRIBUTE_DATE2

TCLAYFLD_ATTRIBUTE_DATE3

TCLAYFLD_ATTRIBUTE_DATE4

TCLAYFLD_ATTRIBUTE_DATE5

TCLAYFLD_ATTRIBUTE_DATE6

TCLAYFLD_ATTRIBUTE_DATE7

TCLAYFLD_ATTRIBUTE_DATE8

TCLAYFLD_ATTRIBUTE_DATE9

TCLAYFLD_ATTRIBUTE_DATE10

TCLAYFLD_ATTRIBUTE_DATE11

TCLAYFLD_ATTRIBUTE_DATE12

TCLAYFLD_ATTRIBUTE_DATE13

TCLAYFLD_ATTRIBUTE_DATE14

TCLAYFLD_ATTRIBUTE_DATE15

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

NAME

DESCRIPTION

LABEL

MODULE_ID

TCLAY_ID

TCLAYFLD_DEFNS_CD

SGUID

Query

SQL_Statement
SELECT HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_DEFNS_ID TCLAYFLD_DEFNS_ID, HXT_TCLAYFLD_DEFNS_B.P_TCLAYFLD_DEFNS_ID P_TCLAYFLD_DEFNS_ID, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_DEFNS_INSTANCE_FLAG TCLAYFLD_DEFNS_INSTANCE_FLAG, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_TMPL_ID TCLAYFLD_TMPL_ID, HXT_TCLAYFLD_DEFNS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HXT_TCLAYFLD_DEFNS_B.ENTERPRISE_ID ENTERPRISE_ID, HXT_TCLAYFLD_DEFNS_B.DISPLAY_SEQUENCE DISPLAY_SEQUENCE, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CATEGORY TCLAYFLD_ATTRIBUTE_CATEGORY, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR1 TCLAYFLD_ATTRIBUTE_CHAR1, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR2 TCLAYFLD_ATTRIBUTE_CHAR2, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR3 TCLAYFLD_ATTRIBUTE_CHAR3, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR4 TCLAYFLD_ATTRIBUTE_CHAR4, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR5 TCLAYFLD_ATTRIBUTE_CHAR5, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR6 TCLAYFLD_ATTRIBUTE_CHAR6, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR7 TCLAYFLD_ATTRIBUTE_CHAR7, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR8 TCLAYFLD_ATTRIBUTE_CHAR8, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR9 TCLAYFLD_ATTRIBUTE_CHAR9, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR10 TCLAYFLD_ATTRIBUTE_CHAR10, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR11 TCLAYFLD_ATTRIBUTE_CHAR11, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR12 TCLAYFLD_ATTRIBUTE_CHAR12, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR13 TCLAYFLD_ATTRIBUTE_CHAR13, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR14 TCLAYFLD_ATTRIBUTE_CHAR14, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR15 TCLAYFLD_ATTRIBUTE_CHAR15, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR16 TCLAYFLD_ATTRIBUTE_CHAR16, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR17 TCLAYFLD_ATTRIBUTE_CHAR17, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR18 TCLAYFLD_ATTRIBUTE_CHAR18, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR19 TCLAYFLD_ATTRIBUTE_CHAR19, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR20 TCLAYFLD_ATTRIBUTE_CHAR20, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR21 TCLAYFLD_ATTRIBUTE_CHAR21, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR22 TCLAYFLD_ATTRIBUTE_CHAR22, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR23 TCLAYFLD_ATTRIBUTE_CHAR23, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR24 TCLAYFLD_ATTRIBUTE_CHAR24, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR25 TCLAYFLD_ATTRIBUTE_CHAR25, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR26 TCLAYFLD_ATTRIBUTE_CHAR26, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR27 TCLAYFLD_ATTRIBUTE_CHAR27, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR28 TCLAYFLD_ATTRIBUTE_CHAR28, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR29 TCLAYFLD_ATTRIBUTE_CHAR29, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR30 TCLAYFLD_ATTRIBUTE_CHAR30, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER1 TCLAYFLD_ATTRIBUTE_NUMBER1, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER2 TCLAYFLD_ATTRIBUTE_NUMBER2, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER3 TCLAYFLD_ATTRIBUTE_NUMBER3, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER4 TCLAYFLD_ATTRIBUTE_NUMBER4, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER5 TCLAYFLD_ATTRIBUTE_NUMBER5, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER6 TCLAYFLD_ATTRIBUTE_NUMBER6, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER7 TCLAYFLD_ATTRIBUTE_NUMBER7, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER8 TCLAYFLD_ATTRIBUTE_NUMBER8, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER9 TCLAYFLD_ATTRIBUTE_NUMBER9, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER10 TCLAYFLD_ATTRIBUTE_NUMBER10, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER11 TCLAYFLD_ATTRIBUTE_NUMBER11, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER12 TCLAYFLD_ATTRIBUTE_NUMBER12, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER13 TCLAYFLD_ATTRIBUTE_NUMBER13, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER14 TCLAYFLD_ATTRIBUTE_NUMBER14, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER15 TCLAYFLD_ATTRIBUTE_NUMBER15, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER16 TCLAYFLD_ATTRIBUTE_NUMBER16, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER17 TCLAYFLD_ATTRIBUTE_NUMBER17, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER18 TCLAYFLD_ATTRIBUTE_NUMBER18, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER19 TCLAYFLD_ATTRIBUTE_NUMBER19, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER20 TCLAYFLD_ATTRIBUTE_NUMBER20, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE1 TCLAYFLD_ATTRIBUTE_DATE1, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE2 TCLAYFLD_ATTRIBUTE_DATE2, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE3 TCLAYFLD_ATTRIBUTE_DATE3, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE4 TCLAYFLD_ATTRIBUTE_DATE4, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE5 TCLAYFLD_ATTRIBUTE_DATE5, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE6 TCLAYFLD_ATTRIBUTE_DATE6, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE7 TCLAYFLD_ATTRIBUTE_DATE7, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE8 TCLAYFLD_ATTRIBUTE_DATE8, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE9 TCLAYFLD_ATTRIBUTE_DATE9, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE10 TCLAYFLD_ATTRIBUTE_DATE10, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE11 TCLAYFLD_ATTRIBUTE_DATE11, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE12 TCLAYFLD_ATTRIBUTE_DATE12, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE13 TCLAYFLD_ATTRIBUTE_DATE13, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE14 TCLAYFLD_ATTRIBUTE_DATE14, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE15 TCLAYFLD_ATTRIBUTE_DATE15, HXT_TCLAYFLD_DEFNS_B.CREATED_BY CREATED_BY, HXT_TCLAYFLD_DEFNS_B.CREATION_DATE CREATION_DATE, HXT_TCLAYFLD_DEFNS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, HXT_TCLAYFLD_DEFNS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HXT_TCLAYFLD_DEFNS_B.LAST_UPDATED_BY LAST_UPDATED_BY, HXT_TCLAYFLD_DEFNS_TL.NAME NAME, HXT_TCLAYFLD_DEFNS_TL.DESCRIPTION DESCRIPTION, HXT_TCLAYFLD_DEFNS_TL.LABEL LABEL, HXT_TCLAYFLD_DEFNS_B.MODULE_ID MODULE_ID, HXT_TCLAYFLD_DEFNS_B.TCLAY_ID TCLAY_ID, HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_DEFNS_CD TCLAYFLD_DEFNS_CD, HXT_TCLAYFLD_DEFNS_B.SGUID SGUID FROM HXT_TCLAYFLD_DEFNS_B, HXT_TCLAYFLD_DEFNS_TL WHERE HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_DEFNS_ID = HXT_TCLAYFLD_DEFNS_TL.TCLAYFLD_DEFNS_ID AND HXT_TCLAYFLD_DEFNS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_DEFNS_ID TCLAYFLD_DEFNS_ID,

HXT_TCLAYFLD_DEFNS_B.P_TCLAYFLD_DEFNS_ID P_TCLAYFLD_DEFNS_ID,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_DEFNS_INSTANCE_FLAG TCLAYFLD_DEFNS_INSTANCE_FLAG,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_TMPL_ID TCLAYFLD_TMPL_ID,

HXT_TCLAYFLD_DEFNS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

HXT_TCLAYFLD_DEFNS_B.ENTERPRISE_ID ENTERPRISE_ID,

HXT_TCLAYFLD_DEFNS_B.DISPLAY_SEQUENCE DISPLAY_SEQUENCE,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CATEGORY TCLAYFLD_ATTRIBUTE_CATEGORY,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR1 TCLAYFLD_ATTRIBUTE_CHAR1,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR2 TCLAYFLD_ATTRIBUTE_CHAR2,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR3 TCLAYFLD_ATTRIBUTE_CHAR3,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR4 TCLAYFLD_ATTRIBUTE_CHAR4,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR5 TCLAYFLD_ATTRIBUTE_CHAR5,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR6 TCLAYFLD_ATTRIBUTE_CHAR6,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR7 TCLAYFLD_ATTRIBUTE_CHAR7,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR8 TCLAYFLD_ATTRIBUTE_CHAR8,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR9 TCLAYFLD_ATTRIBUTE_CHAR9,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR10 TCLAYFLD_ATTRIBUTE_CHAR10,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR11 TCLAYFLD_ATTRIBUTE_CHAR11,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR12 TCLAYFLD_ATTRIBUTE_CHAR12,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR13 TCLAYFLD_ATTRIBUTE_CHAR13,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR14 TCLAYFLD_ATTRIBUTE_CHAR14,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR15 TCLAYFLD_ATTRIBUTE_CHAR15,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR16 TCLAYFLD_ATTRIBUTE_CHAR16,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR17 TCLAYFLD_ATTRIBUTE_CHAR17,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR18 TCLAYFLD_ATTRIBUTE_CHAR18,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR19 TCLAYFLD_ATTRIBUTE_CHAR19,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR20 TCLAYFLD_ATTRIBUTE_CHAR20,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR21 TCLAYFLD_ATTRIBUTE_CHAR21,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR22 TCLAYFLD_ATTRIBUTE_CHAR22,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR23 TCLAYFLD_ATTRIBUTE_CHAR23,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR24 TCLAYFLD_ATTRIBUTE_CHAR24,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR25 TCLAYFLD_ATTRIBUTE_CHAR25,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR26 TCLAYFLD_ATTRIBUTE_CHAR26,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR27 TCLAYFLD_ATTRIBUTE_CHAR27,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR28 TCLAYFLD_ATTRIBUTE_CHAR28,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR29 TCLAYFLD_ATTRIBUTE_CHAR29,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_CHAR30 TCLAYFLD_ATTRIBUTE_CHAR30,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER1 TCLAYFLD_ATTRIBUTE_NUMBER1,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER2 TCLAYFLD_ATTRIBUTE_NUMBER2,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER3 TCLAYFLD_ATTRIBUTE_NUMBER3,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER4 TCLAYFLD_ATTRIBUTE_NUMBER4,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER5 TCLAYFLD_ATTRIBUTE_NUMBER5,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER6 TCLAYFLD_ATTRIBUTE_NUMBER6,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER7 TCLAYFLD_ATTRIBUTE_NUMBER7,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER8 TCLAYFLD_ATTRIBUTE_NUMBER8,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER9 TCLAYFLD_ATTRIBUTE_NUMBER9,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER10 TCLAYFLD_ATTRIBUTE_NUMBER10,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER11 TCLAYFLD_ATTRIBUTE_NUMBER11,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER12 TCLAYFLD_ATTRIBUTE_NUMBER12,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER13 TCLAYFLD_ATTRIBUTE_NUMBER13,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER14 TCLAYFLD_ATTRIBUTE_NUMBER14,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER15 TCLAYFLD_ATTRIBUTE_NUMBER15,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER16 TCLAYFLD_ATTRIBUTE_NUMBER16,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER17 TCLAYFLD_ATTRIBUTE_NUMBER17,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER18 TCLAYFLD_ATTRIBUTE_NUMBER18,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER19 TCLAYFLD_ATTRIBUTE_NUMBER19,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_NUMBER20 TCLAYFLD_ATTRIBUTE_NUMBER20,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE1 TCLAYFLD_ATTRIBUTE_DATE1,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE2 TCLAYFLD_ATTRIBUTE_DATE2,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE3 TCLAYFLD_ATTRIBUTE_DATE3,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE4 TCLAYFLD_ATTRIBUTE_DATE4,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE5 TCLAYFLD_ATTRIBUTE_DATE5,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE6 TCLAYFLD_ATTRIBUTE_DATE6,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE7 TCLAYFLD_ATTRIBUTE_DATE7,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE8 TCLAYFLD_ATTRIBUTE_DATE8,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE9 TCLAYFLD_ATTRIBUTE_DATE9,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE10 TCLAYFLD_ATTRIBUTE_DATE10,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE11 TCLAYFLD_ATTRIBUTE_DATE11,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE12 TCLAYFLD_ATTRIBUTE_DATE12,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE13 TCLAYFLD_ATTRIBUTE_DATE13,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE14 TCLAYFLD_ATTRIBUTE_DATE14,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_ATTRIBUTE_DATE15 TCLAYFLD_ATTRIBUTE_DATE15,

HXT_TCLAYFLD_DEFNS_B.CREATED_BY CREATED_BY,

HXT_TCLAYFLD_DEFNS_B.CREATION_DATE CREATION_DATE,

HXT_TCLAYFLD_DEFNS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

HXT_TCLAYFLD_DEFNS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

HXT_TCLAYFLD_DEFNS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

HXT_TCLAYFLD_DEFNS_TL.NAME NAME,

HXT_TCLAYFLD_DEFNS_TL.DESCRIPTION DESCRIPTION,

HXT_TCLAYFLD_DEFNS_TL.LABEL LABEL,

HXT_TCLAYFLD_DEFNS_B.MODULE_ID MODULE_ID,

HXT_TCLAYFLD_DEFNS_B.TCLAY_ID TCLAY_ID,

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_DEFNS_CD TCLAYFLD_DEFNS_CD,

HXT_TCLAYFLD_DEFNS_B.SGUID SGUID

FROM

HXT_TCLAYFLD_DEFNS_B,

HXT_TCLAYFLD_DEFNS_TL

WHERE

HXT_TCLAYFLD_DEFNS_B.TCLAYFLD_DEFNS_ID = HXT_TCLAYFLD_DEFNS_TL.TCLAYFLD_DEFNS_ID AND HXT_TCLAYFLD_DEFNS_TL.LANGUAGE = USERENV('LANG')