PER_ACTIONS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

ROW_ID ACTION_ID OBJECT_VERSION_NUMBER BUSINESS_GROUP_ID ACTION_CODE DESCRIPTION ACTION_NAME START_DATE END_DATE ACTION_TYPE_ID CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY ACT_ATTRIBUTE_CATEGORY ACT_ATTRIBUTE1 ACT_ATTRIBUTE2 ACT_ATTRIBUTE3 ACT_ATTRIBUTE4 ACT_ATTRIBUTE5 ACT_ATTRIBUTE6 ACT_ATTRIBUTE7 ACT_ATTRIBUTE8 ACT_ATTRIBUTE9 ACT_ATTRIBUTE10 ACT_ATTRIBUTE11 ACT_ATTRIBUTE12 ACT_ATTRIBUTE13 ACT_ATTRIBUTE14 ACT_ATTRIBUTE15 ACT_ATTRIBUTE16 ACT_ATTRIBUTE17 ACT_ATTRIBUTE18 ACT_ATTRIBUTE19 ACT_ATTRIBUTE20 ACT_ATTRIBUTE21 ACT_ATTRIBUTE22 ACT_ATTRIBUTE23 ACT_ATTRIBUTE24 ACT_ATTRIBUTE25 ACT_ATTRIBUTE26 ACT_ATTRIBUTE27 ACT_ATTRIBUTE28 ACT_ATTRIBUTE29 ACT_ATTRIBUTE30 ACTION_TYPE_CODE MODULE_ID ACT_INFORMATION_CATEGORY ACT_INFORMATION1 ACT_INFORMATION2 ACT_INFORMATION3 ACT_INFORMATION4 ACT_INFORMATION5 ACT_INFORMATION6 ACT_INFORMATION7 ACT_INFORMATION8 ACT_INFORMATION9 ACT_INFORMATION10 ACT_INFORMATION11 ACT_INFORMATION12 ACT_INFORMATION13 ACT_INFORMATION14 ACT_INFORMATION15 ACT_INFORMATION16 ACT_INFORMATION17 ACT_INFORMATION18 ACT_INFORMATION19 ACT_INFORMATION20 ACT_INFORMATION21 ACT_INFORMATION22 ACT_INFORMATION23 ACT_INFORMATION24 ACT_INFORMATION25 ACT_INFORMATION26 ACT_INFORMATION27 ACT_INFORMATION28 ACT_INFORMATION29 ACT_INFORMATION30 ACT_INFORMATION_NUMBER1 ACT_INFORMATION_NUMBER2 ACT_INFORMATION_NUMBER3 ACT_INFORMATION_NUMBER4 ACT_INFORMATION_NUMBER5 ACT_INFORMATION_NUMBER6 ACT_INFORMATION_NUMBER7 ACT_INFORMATION_NUMBER8 ACT_INFORMATION_NUMBER9 ACT_INFORMATION_NUMBER10 ACT_INFORMATION_NUMBER11 ACT_INFORMATION_NUMBER12 ACT_INFORMATION_NUMBER13 ACT_INFORMATION_NUMBER14 ACT_INFORMATION_NUMBER15 ACT_INFORMATION_NUMBER16 ACT_INFORMATION_NUMBER17 ACT_INFORMATION_NUMBER18 ACT_INFORMATION_NUMBER19 ACT_INFORMATION_NUMBER20 ACT_INFORMATION_DATE1 ACT_INFORMATION_DATE2 ACT_INFORMATION_DATE3 ACT_INFORMATION_DATE4 ACT_INFORMATION_DATE5 ACT_INFORMATION_DATE6 ACT_INFORMATION_DATE7 ACT_INFORMATION_DATE8 ACT_INFORMATION_DATE9 ACT_INFORMATION_DATE10 ACT_ATTRIBUTE_NUMBER1 ACT_ATTRIBUTE_NUMBER2 ACT_ATTRIBUTE_NUMBER3 ACT_ATTRIBUTE_NUMBER4 ACT_ATTRIBUTE_NUMBER5 ACT_ATTRIBUTE_NUMBER6 ACT_ATTRIBUTE_NUMBER7 ACT_ATTRIBUTE_NUMBER8 ACT_ATTRIBUTE_NUMBER9 ACT_ATTRIBUTE_NUMBER10 ACT_ATTRIBUTE_NUMBER11 ACT_ATTRIBUTE_NUMBER12 ACT_ATTRIBUTE_NUMBER13 ACT_ATTRIBUTE_NUMBER14 ACT_ATTRIBUTE_NUMBER15 ACT_ATTRIBUTE_NUMBER16 ACT_ATTRIBUTE_NUMBER17 ACT_ATTRIBUTE_NUMBER18 ACT_ATTRIBUTE_NUMBER19 ACT_ATTRIBUTE_NUMBER20 ACT_ATTRIBUTE_DATE1 ACT_ATTRIBUTE_DATE2 ACT_ATTRIBUTE_DATE3 ACT_ATTRIBUTE_DATE4 ACT_ATTRIBUTE_DATE5 ACT_ATTRIBUTE_DATE6 ACT_ATTRIBUTE_DATE7 ACT_ATTRIBUTE_DATE8 ACT_ATTRIBUTE_DATE9 ACT_ATTRIBUTE_DATE10 ACT_ATTRIBUTE_DATE11 ACT_ATTRIBUTE_DATE12 ACT_ATTRIBUTE_DATE13 ACT_ATTRIBUTE_DATE14 ACT_ATTRIBUTE_DATE15 ACT_INFORMATION_NUMER2 ACT_INFORMATION_NUMER3 ACT_INFORMATION_NUMER4 ACT_INFORMATION_NUMER5 ACT_INFORMATION_NUMER6 ACT_INFORMATION_NUMER7 ACT_INFORMATION_NUMER8 ACT_INFORMATION_NUMER9 ACT_INFORMATION_NUMER10 ACT_INFORMATION_NUMER11 ACT_INFORMATION_NUMER12 ACT_INFORMATION_NUMER13 ACT_INFORMATION_NUMER14 ACT_INFORMATION_NUMER15 ACT_INFORMATION_NUMER16 ACT_INFORMATION_NUMER17 ACT_INFORMATION_NUMER18 ACT_INFORMATION_NUMER19 ACT_INFORMATION_NUMER20 ACT_INFORMATION_DATE11 ACT_INFORMATION_DATE12 ACT_INFORMATION_DATE13 ACT_INFORMATION_DATE14 ACT_INFORMATION_DATE15 SGUID ALL_ROLES COUNTRY DFLT_ASG_STATUS_TYPE_ID IS_SYSTEM_ACTION USED_IN_CONTRACT

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.ACTION_ID, B.OBJECT_VERSION_NUMBER, B.BUSINESS_GROUP_ID, B.ACTION_CODE, T.DESCRIPTION, T.ACTION_NAME, B.START_DATE, B.END_DATE, B.ACTION_TYPE_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.LAST_UPDATED_BY, B.ACT_ATTRIBUTE_CATEGORY, B.ACT_ATTRIBUTE1, B.ACT_ATTRIBUTE2, B.ACT_ATTRIBUTE3, B.ACT_ATTRIBUTE4, B.ACT_ATTRIBUTE5, B.ACT_ATTRIBUTE6, B.ACT_ATTRIBUTE7, B.ACT_ATTRIBUTE8, B.ACT_ATTRIBUTE9, B.ACT_ATTRIBUTE10, B.ACT_ATTRIBUTE11, B.ACT_ATTRIBUTE12, B.ACT_ATTRIBUTE13, B.ACT_ATTRIBUTE14, B.ACT_ATTRIBUTE15, B.ACT_ATTRIBUTE16, B.ACT_ATTRIBUTE17, B.ACT_ATTRIBUTE18, B.ACT_ATTRIBUTE19, B.ACT_ATTRIBUTE20, B.ACT_ATTRIBUTE21, B.ACT_ATTRIBUTE22, B.ACT_ATTRIBUTE23, B.ACT_ATTRIBUTE24, B.ACT_ATTRIBUTE25, B.ACT_ATTRIBUTE26, B.ACT_ATTRIBUTE27, B.ACT_ATTRIBUTE28, B.ACT_ATTRIBUTE29, B.ACT_ATTRIBUTE30, B.ACTION_TYPE_CODE, B.MODULE_ID, B.ACT_INFORMATION_CATEGORY ACT_INFORMATION_CATEGORY, B.ACT_INFORMATION1 ACT_INFORMATION1, B.ACT_INFORMATION2 ACT_INFORMATION2, B.ACT_INFORMATION3 ACT_INFORMATION3, B.ACT_INFORMATION4 ACT_INFORMATION4, B.ACT_INFORMATION5 ACT_INFORMATION5, B.ACT_INFORMATION6 ACT_INFORMATION6, B.ACT_INFORMATION7 ACT_INFORMATION7, B.ACT_INFORMATION8 ACT_INFORMATION8, B.ACT_INFORMATION9 ACT_INFORMATION9, B.ACT_INFORMATION10 ACT_INFORMATION10, B.ACT_INFORMATION11 ACT_INFORMATION11, B.ACT_INFORMATION12 ACT_INFORMATION12, B.ACT_INFORMATION13 ACT_INFORMATION13, B.ACT_INFORMATION14 ACT_INFORMATION14, B.ACT_INFORMATION15 ACT_INFORMATION15, B.ACT_INFORMATION16 ACT_INFORMATION16, B.ACT_INFORMATION17 ACT_INFORMATION17, B.ACT_INFORMATION18 ACT_INFORMATION18, B.ACT_INFORMATION19 ACT_INFORMATION19, B.ACT_INFORMATION20 ACT_INFORMATION20, B.ACT_INFORMATION21 ACT_INFORMATION21, B.ACT_INFORMATION22 ACT_INFORMATION22, B.ACT_INFORMATION23 ACT_INFORMATION23, B.ACT_INFORMATION24 ACT_INFORMATION24, B.ACT_INFORMATION25 ACT_INFORMATION25, B.ACT_INFORMATION26 ACT_INFORMATION26, B.ACT_INFORMATION27 ACT_INFORMATION27, B.ACT_INFORMATION28 ACT_INFORMATION28, B.ACT_INFORMATION29 ACT_INFORMATION29, B.ACT_INFORMATION30 ACT_INFORMATION30, B.ACT_INFORMATION_NUMBER1 ACT_INFORMATION_NUMBER1, B.ACT_INFORMATION_NUMBER2 ACT_INFORMATION_NUMBER2, B.ACT_INFORMATION_NUMBER3 ACT_INFORMATION_NUMBER3, B.ACT_INFORMATION_NUMBER4 ACT_INFORMATION_NUMBER4, B.ACT_INFORMATION_NUMBER5 ACT_INFORMATION_NUMBER5, B.ACT_INFORMATION_NUMBER6 ACT_INFORMATION_NUMBER6, B.ACT_INFORMATION_NUMBER7 ACT_INFORMATION_NUMBER7, B.ACT_INFORMATION_NUMBER8 ACT_INFORMATION_NUMBER8, B.ACT_INFORMATION_NUMBER9 ACT_INFORMATION_NUMBER9, B.ACT_INFORMATION_NUMBER10 ACT_INFORMATION_NUMBER10, B.ACT_INFORMATION_NUMBER11 ACT_INFORMATION_NUMBER11, B.ACT_INFORMATION_NUMBER12 ACT_INFORMATION_NUMBER12, B.ACT_INFORMATION_NUMBER13 ACT_INFORMATION_NUMBER13, B.ACT_INFORMATION_NUMBER14 ACT_INFORMATION_NUMBER14, B.ACT_INFORMATION_NUMBER15 ACT_INFORMATION_NUMBER15, B.ACT_INFORMATION_NUMBER16 ACT_INFORMATION_NUMBER16, B.ACT_INFORMATION_NUMBER17 ACT_INFORMATION_NUMBER17, B.ACT_INFORMATION_NUMBER18 ACT_INFORMATION_NUMBER18, B.ACT_INFORMATION_NUMBER19 ACT_INFORMATION_NUMBER19, B.ACT_INFORMATION_NUMBER20 ACT_INFORMATION_NUMBER20, B.ACT_INFORMATION_DATE1 ACT_INFORMATION_DATE1, B.ACT_INFORMATION_DATE2 ACT_INFORMATION_DATE2, B.ACT_INFORMATION_DATE3 ACT_INFORMATION_DATE3, B.ACT_INFORMATION_DATE4 ACT_INFORMATION_DATE4, B.ACT_INFORMATION_DATE5 ACT_INFORMATION_DATE5, B.ACT_INFORMATION_DATE6 ACT_INFORMATION_DATE6, B.ACT_INFORMATION_DATE7 ACT_INFORMATION_DATE7, B.ACT_INFORMATION_DATE8 ACT_INFORMATION_DATE8, B.ACT_INFORMATION_DATE9 ACT_INFORMATION_DATE9, B.ACT_INFORMATION_DATE10 ACT_INFORMATION_DATE10, B.ACT_ATTRIBUTE_NUMBER1, B.ACT_ATTRIBUTE_NUMBER2, B.ACT_ATTRIBUTE_NUMBER3, B.ACT_ATTRIBUTE_NUMBER4, B.ACT_ATTRIBUTE_NUMBER5, B.ACT_ATTRIBUTE_NUMBER6, B.ACT_ATTRIBUTE_NUMBER7, B.ACT_ATTRIBUTE_NUMBER8, B.ACT_ATTRIBUTE_NUMBER9, B.ACT_ATTRIBUTE_NUMBER10, B.ACT_ATTRIBUTE_NUMBER11, B.ACT_ATTRIBUTE_NUMBER12, B.ACT_ATTRIBUTE_NUMBER13, B.ACT_ATTRIBUTE_NUMBER14, B.ACT_ATTRIBUTE_NUMBER15, B.ACT_ATTRIBUTE_NUMBER16, B.ACT_ATTRIBUTE_NUMBER17, B.ACT_ATTRIBUTE_NUMBER18, B.ACT_ATTRIBUTE_NUMBER19, B.ACT_ATTRIBUTE_NUMBER20, B.ACT_ATTRIBUTE_DATE1, B.ACT_ATTRIBUTE_DATE2, B.ACT_ATTRIBUTE_DATE3, B.ACT_ATTRIBUTE_DATE4, B.ACT_ATTRIBUTE_DATE5, B.ACT_ATTRIBUTE_DATE6, B.ACT_ATTRIBUTE_DATE7, B.ACT_ATTRIBUTE_DATE8, B.ACT_ATTRIBUTE_DATE9, B.ACT_ATTRIBUTE_DATE10, B.ACT_ATTRIBUTE_DATE11, B.ACT_ATTRIBUTE_DATE12, B.ACT_ATTRIBUTE_DATE13, B.ACT_ATTRIBUTE_DATE14, B.ACT_ATTRIBUTE_DATE15, B.ACT_INFORMATION_NUMER2, B.ACT_INFORMATION_NUMER3, B.ACT_INFORMATION_NUMER4, B.ACT_INFORMATION_NUMER5, B.ACT_INFORMATION_NUMER6, B.ACT_INFORMATION_NUMER7, B.ACT_INFORMATION_NUMER8, B.ACT_INFORMATION_NUMER9, B.ACT_INFORMATION_NUMER10, B.ACT_INFORMATION_NUMER11, B.ACT_INFORMATION_NUMER12, B.ACT_INFORMATION_NUMER13, B.ACT_INFORMATION_NUMER14, B.ACT_INFORMATION_NUMER15, B.ACT_INFORMATION_NUMER16, B.ACT_INFORMATION_NUMER17, B.ACT_INFORMATION_NUMER18, B.ACT_INFORMATION_NUMER19, B.ACT_INFORMATION_NUMER20, B.ACT_INFORMATION_DATE11, B.ACT_INFORMATION_DATE12, B.ACT_INFORMATION_DATE13, B.ACT_INFORMATION_DATE14, B.ACT_INFORMATION_DATE15, B.SGUID SGUID, B.ALL_ROLES, B.COUNTRY, B.DFLT_ASG_STATUS_TYPE_ID, B.IS_SYSTEM_ACTION, B.USED_IN_CONTRACT FROM PER_ACTIONS_B B, PER_ACTIONS_TL T WHERE B.ACTION_ID = T.ACTION_ID AND T.LANGUAGE = USERENV('LANG')