HR_GEN_AI_AGENTS

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
AGENT_ID AGENT_CODE FAMILY PRODUCT AGENT_CREATED_DATE OWNER_ID OWNER_NAME STATUS PROMPT_CODE NAMESPACE VERSION SPECIFICATION SEEDED_FLAG MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NAME DESCRIPTION

Name

AGENT_ID

AGENT_CODE

FAMILY

PRODUCT

AGENT_CREATED_DATE

OWNER_ID

OWNER_NAME

STATUS

PROMPT_CODE

NAMESPACE

VERSION

SPECIFICATION

SEEDED_FLAG

MODULE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

Query

SQL_Statement
SELECT B.AGENT_ID, B.AGENT_CODE, B.FAMILY, B.PRODUCT, B.AGENT_CREATED_DATE, B.OWNER_ID, B.OWNER_NAME, B.STATUS, B.PROMPT_CODE, B.NAMESPACE, B.VERSION, B.SPECIFICATION, B.SEEDED_FLAG, B.MODULE_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, T.NAME, T.DESCRIPTION FROM HR_GEN_AI_AGENTS_B B, HR_GEN_AI_AGENTS_TL T WHERE B.AGENT_ID=T.AGENT_ID AND T.LANGUAGE=USERENV('LANG')

SQL_Statement

SELECT

B.AGENT_ID,

B.AGENT_CODE,

B.FAMILY,

B.PRODUCT,

B.AGENT_CREATED_DATE,

B.OWNER_ID,

B.OWNER_NAME,

B.STATUS,

B.PROMPT_CODE,

B.NAMESPACE,

B.VERSION,

B.SPECIFICATION,

B.SEEDED_FLAG,

B.MODULE_ID,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

T.NAME,

T.DESCRIPTION

FROM

HR_GEN_AI_AGENTS_B B,

HR_GEN_AI_AGENTS_TL T

WHERE

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