PER_ASSIGNMENT_STATUS_TYPES_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
ROW_ID ASSIGNMENT_STATUS_TYPE_ID BUSINESS_GROUP_ID LEGISLATION_CODE USER_STATUS EXTERNAL_STATUS ACTIVE_FLAG DEFAULT_FLAG PRIMARY_FLAG PAY_SYSTEM_STATUS PER_SYSTEM_STATUS LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER START_DATE END_DATE ASSIGNMENT_STATUS_CODE ORIG_ASSIGN_STATUS_TYPE_ID MODULE_ID SGUID COUNTRY

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.ASSIGNMENT_STATUS_TYPE_ID, B.BUSINESS_GROUP_ID, B.LEGISLATION_CODE, T.USER_STATUS, T.EXTERNAL_STATUS, B.ACTIVE_FLAG, B.DEFAULT_FLAG, B.PRIMARY_FLAG, B.PAY_SYSTEM_STATUS, B.PER_SYSTEM_STATUS, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.CREATION_DATE, B.OBJECT_VERSION_NUMBER, B.START_DATE, B.END_DATE, B.ASSIGNMENT_STATUS_CODE, B.ORIG_ASSIGN_STATUS_TYPE_ID, B.MODULE_ID, B.SGUID SGUID, B.COUNTRY FROM PER_ASSIGNMENT_STATUS_TYPES B, PER_ASSIGNMENT_STATUS_TYPES_TL T WHERE B.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID AND T.LANGUAGE = USERENV('LANG')