DOO_HOLD_CODES_VL
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: VIEW
Columns
Name |
---|
HOLD_CODE_ID OBJECT_VERSION_NUMBER HOLD_CODE HOLD_NAME HOLD_DESCRIPTION SET_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE GENERAL_HOLD_FLAG SYSTEM_FLAG CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ORCHESTRATION_APPLICATION_ID APPLY_HOLD_ROLE_ELIGIBILITY RELEASE_HOLD_ROLE_ELIGIBILITY |
Query
SQL_Statement |
---|
SELECT b.HOLD_CODE_ID, b.OBJECT_VERSION_NUMBER, b.HOLD_CODE, t.HOLD_NAME, t.HOLD_DESCRIPTION, b.SET_ID, b.EFFECTIVE_START_DATE, b.EFFECTIVE_END_DATE, b.GENERAL_HOLD_FLAG, b.SYSTEM_FLAG, b.CREATION_DATE, b.CREATED_BY, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.ORCHESTRATION_APPLICATION_ID, b.APPLY_HOLD_ROLE_ELIGIBILITY, b.RELEASE_HOLD_ROLE_ELIGIBILITY FROM DOO_HOLD_CODES_B b, DOO_HOLD_CODES_TL t WHERE t.HOLD_CODE_ID = b.HOLD_CODE_ID AND t.LANGUAGE = USERENV('LANG') |