HR_GEN_AI_PROMPTS_SEED_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
PROMPT_TMPL_AI_ID PROMPT_CODE PROMPT_TMPL_VERSION ENABLED_FLAG USE_CASE_ID PROMPT PROMPT_TMPL OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN MODULE_ID FAMILY PRODUCT AVAILABLE_TOKENS MODEL_CODE MODEL_VERSION MODEL_PROVIDER CONFIGURABLE PERSIST_DATA LABEL DESCRIPTION

Query

SQL_Statement

SELECT B.PROMPT_TMPL_AI_ID, B.PROMPT_CODE PROMPT_CODE, B.PROMPT_TMPL_VERSION, B.ENABLED_FLAG, B.USE_CASE_ID USE_CASE_ID, B.PROMPT PROMPT, B.PROMPT_TMPL, 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, B.MODEL_CODE, B.MODEL_VERSION, B.MODEL_PROVIDER, B.CONFIGURABLE, B.PERSIST_DATA, T.LABEL LABEL, T.DESCRIPTION DESCRIPTION FROM HR_GEN_AI_PROMPTS_SEED_B B, HR_GEN_AI_PROMPTS_SEED_TL T WHERE B.PROMPT_TMPL_AI_ID=T.PROMPT_TMPL_AI_ID AND T.LANGUAGE=USERENV('LANG')