HRY_PIINBDRECRDINFORMATION_MSV

Details

• Schema: FUSION

• Object owner: HRY

• Object type: VIEW

Columns

Name

INBD_RECORD_INFO_ID INBD_RECORD_ID IRI_INFORMATION_CONTEXT IRI_INFORMATION1 IRI_INFORMATION2 IRI_INFORMATION3 IRI_INFORMATION4 IRI_INFORMATION5 IRI_INFORMATION6 IRI_INFORMATION7 IRI_INFORMATION8 IRI_INFORMATION9 IRI_INFORMATION10 IRI_INFORMATION11 IRI_INFORMATION12 IRI_INFORMATION13 IRI_INFORMATION14 IRI_INFORMATION15 IRI_INFORMATION16 IRI_INFORMATION17 IRI_INFORMATION18 IRI_INFORMATION19 IRI_INFORMATION20 IRI_INFORMATION21 IRI_INFORMATION22 IRI_INFORMATION23 IRI_INFORMATION24 IRI_INFORMATION25 IRI_INFORMATION26 IRI_INFORMATION27 IRI_INFORMATION28 IRI_INFORMATION29 IRI_INFORMATION30 IRI_INFORMATION31 IRI_INFORMATION32 IRI_INFORMATION33 IRI_INFORMATION34 IRI_INFORMATION35 IRI_INFORMATION36 IRI_INFORMATION37 IRI_INFORMATION38 IRI_INFORMATION39 IRI_INFORMATION40 IRI_INFORMATION41 IRI_INFORMATION42 IRI_INFORMATION43 IRI_INFORMATION44 IRI_INFORMATION45 IRI_INFORMATION46 IRI_INFORMATION47 IRI_INFORMATION48 IRI_INFORMATION49 IRI_INFORMATION50 IRI_INFORMATION_NUMBER1 IRI_INFORMATION_NUMBER2 IRI_INFORMATION_NUMBER3 IRI_INFORMATION_NUMBER4 IRI_INFORMATION_NUMBER5 IRI_INFORMATION_NUMBER6 IRI_INFORMATION_NUMBER7 IRI_INFORMATION_NUMBER8 IRI_INFORMATION_NUMBER9 IRI_INFORMATION_NUMBER10 IRI_INFORMATION_NUMBER11 IRI_INFORMATION_NUMBER12 IRI_INFORMATION_NUMBER13 IRI_INFORMATION_NUMBER14 IRI_INFORMATION_NUMBER15 IRI_INFORMATION_NUMBER16 IRI_INFORMATION_NUMBER17 IRI_INFORMATION_NUMBER18 IRI_INFORMATION_NUMBER19 IRI_INFORMATION_NUMBER20 IRI_INFORMATION_NUMBER21 IRI_INFORMATION_NUMBER22 IRI_INFORMATION_NUMBER23 IRI_INFORMATION_NUMBER24 IRI_INFORMATION_NUMBER25 IRI_INFORMATION_NUMBER26 IRI_INFORMATION_NUMBER27 IRI_INFORMATION_NUMBER28 IRI_INFORMATION_NUMBER29 IRI_INFORMATION_NUMBER30 IRI_INFORMATION_DATE1 IRI_INFORMATION_DATE2 IRI_INFORMATION_DATE3 IRI_INFORMATION_DATE4 IRI_INFORMATION_DATE5 IRI_INFORMATION_DATE6 IRI_INFORMATION_DATE7 IRI_INFORMATION_DATE8 IRI_INFORMATION_DATE9 IRI_INFORMATION_DATE10 IRI_INFORMATION_DATE11 IRI_INFORMATION_DATE12 IRI_INFORMATION_DATE13 IRI_INFORMATION_DATE14 IRI_INFORMATION_DATE15 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ENTERPRISE_ID

Query

SQL_Statement

SELECT INBD_RECORD_INFO_ID, INBD_RECORD_ID, IRI_INFORMATION_CONTEXT, IRI_INFORMATION1, IRI_INFORMATION2, IRI_INFORMATION3, IRI_INFORMATION4, IRI_INFORMATION5, IRI_INFORMATION6, IRI_INFORMATION7, IRI_INFORMATION8, IRI_INFORMATION9, IRI_INFORMATION10, IRI_INFORMATION11, IRI_INFORMATION12, IRI_INFORMATION13, IRI_INFORMATION14, IRI_INFORMATION15, IRI_INFORMATION16, IRI_INFORMATION17, IRI_INFORMATION18, IRI_INFORMATION19, IRI_INFORMATION20, IRI_INFORMATION21, IRI_INFORMATION22, IRI_INFORMATION23, IRI_INFORMATION24, IRI_INFORMATION25, IRI_INFORMATION26, IRI_INFORMATION27, IRI_INFORMATION28, IRI_INFORMATION29, cast(DECODE(IRI_INFORMATION_CONTEXT,'ORA_HRY_PAYMENT_INFO','Secure',IRI_INFORMATION30) As Varchar2(150 CHAR)) IRI_INFORMATION30, IRI_INFORMATION31, IRI_INFORMATION32, IRI_INFORMATION33, IRI_INFORMATION34, IRI_INFORMATION35, IRI_INFORMATION36, IRI_INFORMATION37, IRI_INFORMATION38, IRI_INFORMATION39, IRI_INFORMATION40, IRI_INFORMATION41, IRI_INFORMATION42, IRI_INFORMATION43, IRI_INFORMATION44, IRI_INFORMATION45, IRI_INFORMATION46, IRI_INFORMATION47, IRI_INFORMATION48, IRI_INFORMATION49, IRI_INFORMATION50, IRI_INFORMATION_NUMBER1, IRI_INFORMATION_NUMBER2, IRI_INFORMATION_NUMBER3, IRI_INFORMATION_NUMBER4, IRI_INFORMATION_NUMBER5, IRI_INFORMATION_NUMBER6, IRI_INFORMATION_NUMBER7, IRI_INFORMATION_NUMBER8, IRI_INFORMATION_NUMBER9, IRI_INFORMATION_NUMBER10, IRI_INFORMATION_NUMBER11, IRI_INFORMATION_NUMBER12, IRI_INFORMATION_NUMBER13, IRI_INFORMATION_NUMBER14, IRI_INFORMATION_NUMBER15, IRI_INFORMATION_NUMBER16, IRI_INFORMATION_NUMBER17, IRI_INFORMATION_NUMBER18, IRI_INFORMATION_NUMBER19, IRI_INFORMATION_NUMBER20, IRI_INFORMATION_NUMBER21, IRI_INFORMATION_NUMBER22, IRI_INFORMATION_NUMBER23, IRI_INFORMATION_NUMBER24, IRI_INFORMATION_NUMBER25, IRI_INFORMATION_NUMBER26, IRI_INFORMATION_NUMBER27, IRI_INFORMATION_NUMBER28, IRI_INFORMATION_NUMBER29, IRI_INFORMATION_NUMBER30, IRI_INFORMATION_DATE1, IRI_INFORMATION_DATE2, IRI_INFORMATION_DATE3, IRI_INFORMATION_DATE4, IRI_INFORMATION_DATE5, IRI_INFORMATION_DATE6, IRI_INFORMATION_DATE7, IRI_INFORMATION_DATE8, IRI_INFORMATION_DATE9, IRI_INFORMATION_DATE10, IRI_INFORMATION_DATE11, IRI_INFORMATION_DATE12, IRI_INFORMATION_DATE13, IRI_INFORMATION_DATE14, IRI_INFORMATION_DATE15, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, ENTERPRISE_ID FROM fusion.HRY_PI_INBD_RECORD_INFORMATION