HR_LOOKUPS

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
APPLICATION_ID LOOKUP_TYPE LOOKUP_CODE MEANING DESCRIPTION ENABLED_FLAG DISPLAY_SEQUENCE START_DATE_ACTIVE END_DATE_ACTIVE TAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE

Query

SQL_Statement

SELECT NULL APPLICATION_ID, B.LOOKUP_TYPE, B.LOOKUP_CODE, T.MEANING, T.DESCRIPTION, B.ENABLED_FLAG, B.DISPLAY_SEQUENCE, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.TAG, T.CREATED_BY, T.CREATION_DATE, T.LAST_UPDATED_BY, T.LAST_UPDATE_LOGIN, T.LAST_UPDATE_DATE FROM FND_LOOKUP_VALUES_TL T, FND_LOOKUP_VALUES_B B WHERE T.LOOKUP_TYPE = B.LOOKUP_TYPE AND T.LOOKUP_CODE = B.LOOKUP_CODE AND T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID AND T.SET_ID = B.SET_ID AND T.LANGUAGE = USERENV('LANG') AND T.VIEW_APPLICATION_ID=3 AND decode(B.TAG, NULL, 'Y', decode(substr(B.TAG,1,1), '+', decode(sign(instr(B.TAG, HR_API.GET_LEGISLATION_CONTEXT)), 1, 'Y', 'N'), '-', decode(sign(instr(B.TAG, HR_API.GET_LEGISLATION_CONTEXT)), 1, 'N', 'Y'), 'Y' ) ) = 'Y'