PER_ACTION_REASONS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

ROW_ID ACTION_REASON_ID OBJECT_VERSION_NUMBER BUSINESS_GROUP_ID ACTION_REASON_CODE ACTION_REASON DESCRIPTION START_DATE END_DATE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY RSN_ATTRIBUTE_CATEGORY RSN_ATTRIBUTE1 RSN_ATTRIBUTE2 RSN_ATTRIBUTE3 RSN_ATTRIBUTE4 RSN_ATTRIBUTE5 RSN_ATTRIBUTE6 RSN_ATTRIBUTE7 RSN_ATTRIBUTE8 RSN_ATTRIBUTE9 RSN_ATTRIBUTE10 RSN_ATTRIBUTE11 RSN_ATTRIBUTE12 RSN_ATTRIBUTE13 RSN_ATTRIBUTE14 RSN_ATTRIBUTE15 RSN_ATTRIBUTE16 RSN_ATTRIBUTE17 RSN_ATTRIBUTE18 RSN_ATTRIBUTE19 RSN_ATTRIBUTE20 RSN_ATTRIBUTE21 RSN_ATTRIBUTE22 RSN_ATTRIBUTE23 RSN_ATTRIBUTE24 RSN_ATTRIBUTE25 RSN_ATTRIBUTE26 RSN_ATTRIBUTE27 RSN_ATTRIBUTE28 RSN_ATTRIBUTE29 RSN_ATTRIBUTE30 MODULE_ID RSN_ATTRIBUTE_NUMBER1 RSN_ATTRIBUTE_NUMBER2 RSN_ATTRIBUTE_NUMBER3 RSN_ATTRIBUTE_NUMBER4 RSN_ATTRIBUTE_NUMBER5 RSN_ATTRIBUTE_NUMBER6 RSN_ATTRIBUTE_NUMBER7 RSN_ATTRIBUTE_NUMBER8 RSN_ATTRIBUTE_NUMBER9 RSN_ATTRIBUTE_NUMBER10 RSN_ATTRIBUTE_NUMBER11 RSN_ATTRIBUTE_NUMBER12 RSN_ATTRIBUTE_NUMBER13 RSN_ATTRIBUTE_NUMBER14 RSN_ATTRIBUTE_NUMBER15 RSN_ATTRIBUTE_NUMBER16 RSN_ATTRIBUTE_NUMBER17 RSN_ATTRIBUTE_NUMBER18 RSN_ATTRIBUTE_NUMBER19 RSN_ATTRIBUTE_NUMBER20 RSN_ATTRIBUTE_DATE1 RSN_ATTRIBUTE_DATE2 RSN_ATTRIBUTE_DATE3 RSN_ATTRIBUTE_DATE4 RSN_ATTRIBUTE_DATE5 RSN_ATTRIBUTE_DATE6 RSN_ATTRIBUTE_DATE7 RSN_ATTRIBUTE_DATE8 RSN_ATTRIBUTE_DATE9 RSN_ATTRIBUTE_DATE10 RSN_ATTRIBUTE_DATE11 RSN_ATTRIBUTE_DATE12 RSN_ATTRIBUTE_DATE13 RSN_ATTRIBUTE_DATE14 RSN_ATTRIBUTE_DATE15 SGUID

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.ACTION_REASON_ID, B.OBJECT_VERSION_NUMBER, B.BUSINESS_GROUP_ID, B.ACTION_REASON_CODE, T.ACTION_REASON, T.Description, B.START_DATE, B.END_DATE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.LAST_UPDATED_BY, B.RSN_ATTRIBUTE_CATEGORY, B.RSN_ATTRIBUTE1, B.RSN_ATTRIBUTE2, B.RSN_ATTRIBUTE3, B.RSN_ATTRIBUTE4, B.RSN_ATTRIBUTE5, B.RSN_ATTRIBUTE6, B.RSN_ATTRIBUTE7, B.RSN_ATTRIBUTE8, B.RSN_ATTRIBUTE9, B.RSN_ATTRIBUTE10, B.RSN_ATTRIBUTE11, B.RSN_ATTRIBUTE12, B.RSN_ATTRIBUTE13, B.RSN_ATTRIBUTE14, B.RSN_ATTRIBUTE15, B.RSN_ATTRIBUTE16, B.RSN_ATTRIBUTE17, B.RSN_ATTRIBUTE18, B.RSN_ATTRIBUTE19, B.RSN_ATTRIBUTE20, B.RSN_ATTRIBUTE21, B.RSN_ATTRIBUTE22, B.RSN_ATTRIBUTE23, B.RSN_ATTRIBUTE24, B.RSN_ATTRIBUTE25, B.RSN_ATTRIBUTE26, B.RSN_ATTRIBUTE27, B.RSN_ATTRIBUTE28, B.RSN_ATTRIBUTE29, B.RSN_ATTRIBUTE30, B.MODULE_ID, B.RSN_ATTRIBUTE_NUMBER1, B.RSN_ATTRIBUTE_NUMBER2, B.RSN_ATTRIBUTE_NUMBER3, B.RSN_ATTRIBUTE_NUMBER4, B.RSN_ATTRIBUTE_NUMBER5, B.RSN_ATTRIBUTE_NUMBER6, B.RSN_ATTRIBUTE_NUMBER7, B.RSN_ATTRIBUTE_NUMBER8, B.RSN_ATTRIBUTE_NUMBER9, B.RSN_ATTRIBUTE_NUMBER10, B.RSN_ATTRIBUTE_NUMBER11, B.RSN_ATTRIBUTE_NUMBER12, B.RSN_ATTRIBUTE_NUMBER13, B.RSN_ATTRIBUTE_NUMBER14, B.RSN_ATTRIBUTE_NUMBER15, B.RSN_ATTRIBUTE_NUMBER16, B.RSN_ATTRIBUTE_NUMBER17, B.RSN_ATTRIBUTE_NUMBER18, B.RSN_ATTRIBUTE_NUMBER19, B.RSN_ATTRIBUTE_NUMBER20, B.RSN_ATTRIBUTE_DATE1, B.RSN_ATTRIBUTE_DATE2, B.RSN_ATTRIBUTE_DATE3, B.RSN_ATTRIBUTE_DATE4, B.RSN_ATTRIBUTE_DATE5, B.RSN_ATTRIBUTE_DATE6, B.RSN_ATTRIBUTE_DATE7, B.RSN_ATTRIBUTE_DATE8, B.RSN_ATTRIBUTE_DATE9, B.RSN_ATTRIBUTE_DATE10, B.RSN_ATTRIBUTE_DATE11, B.RSN_ATTRIBUTE_DATE12, B.RSN_ATTRIBUTE_DATE13, B.RSN_ATTRIBUTE_DATE14, B.RSN_ATTRIBUTE_DATE15, B.SGUID SGUID FROM PER_ACTION_REASONS_B B, PER_ACTION_REASONS_TL T WHERE B.ACTION_REASON_ID = T.ACTION_REASON_ID AND T.LANGUAGE = USERENV('LANG')