HR_GEN_AI_PROMPTS_SEED_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
PROMPT_CODE USE_CASE_ID PROMPT OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN MODULE_ID FAMILY PRODUCT AVAILABLE_TOKENS LABEL DESCRIPTION

Query

SQL_Statement

SELECT B.PROMPT_CODE PROMPT_CODE, B.USE_CASE_ID USE_CASE_ID, B.PROMPT PROMPT, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.MODULE_ID MODULE_ID, B.FAMILY FAMILY, B.PRODUCT PRODUCT, B.AVAILABLE_TOKENS, T.LABEL LABEL, T.DESCRIPTION DESCRIPTION FROM HR_GEN_AI_PROMPTS_SEED_B B, HR_GEN_AI_PROMPTS_SEED_TL T WHERE B.PROMPT_CODE=T.PROMPT_CODE AND T.LANGUAGE=USERENV('LANG')