HR_GEN_AI_TOOLS

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
TOOL_ID TOOL_CODE TYPE FAMILY PRODUCT TOOL_CREATED_DATE OWNER_ID OWNER_NAME NAMESPACE STATUS VERSION MODULE_ID HIDDEN_FLAG SEEDED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NAME DESCRIPTION

Name

TOOL_ID

TOOL_CODE

TYPE

FAMILY

PRODUCT

TOOL_CREATED_DATE

OWNER_ID

OWNER_NAME

NAMESPACE

STATUS

VERSION

MODULE_ID

HIDDEN_FLAG

SEEDED_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

Query

SQL_Statement
SELECT B.TOOL_ID, B.TOOL_CODE, B.TYPE, B.FAMILY, B.PRODUCT, B.TOOL_CREATED_DATE, B.OWNER_ID, B.OWNER_NAME, B.NAMESPACE, B.STATUS, B.VERSION, B.MODULE_ID, B.HIDDEN_FLAG, B.SEEDED_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, T.NAME NAME, T.DESCRIPTION FROM HR_GEN_AI_TOOLS_B B, HR_GEN_AI_TOOLS_TL T WHERE B.TOOL_ID=T.TOOL_ID AND T.LANGUAGE=USERENV('LANG')

SQL_Statement

SELECT

B.TOOL_ID,

B.TOOL_CODE,

B.TYPE,

B.FAMILY,

B.PRODUCT,

B.TOOL_CREATED_DATE,

B.OWNER_ID,

B.OWNER_NAME,

B.NAMESPACE,

B.STATUS,

B.VERSION,

B.MODULE_ID,

B.HIDDEN_FLAG,

B.SEEDED_FLAG,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

T.NAME NAME,

T.DESCRIPTION

FROM

HR_GEN_AI_TOOLS_B B,

HR_GEN_AI_TOOLS_TL T

WHERE

B.TOOL_ID=T.TOOL_ID AND T.LANGUAGE=USERENV('LANG')