ZX_RECOVERY_TYPES_VL
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: VIEW
Columns
Name |
---|
ROW_ID START_DATE PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID ENABLED_FLAG RECOVERY_TYPE_CODE TAX_REGIME_CODE TAX LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 RECOVERY_TYPE_ID END_DATE CREATED_BY CREATION_DATE RECOVERY_TYPE_NAME RECOVERY_TYPE_DESC |
Query
SQL_Statement |
---|
SELECT B.ROWID ROW_ID ,B.START_DATE ,B.PROGRAM_APP_NAME ,B.PROGRAM_NAME ,B.PROGRAM_LOGIN_ID ,B.ENABLED_FLAG ,B.RECOVERY_TYPE_CODE ,B.TAX_REGIME_CODE ,B.TAX ,B.LAST_UPDATED_BY ,B.LAST_UPDATE_DATE ,B.LAST_UPDATE_LOGIN ,B.REQUEST_ID ,B.ATTRIBUTE_CATEGORY ,B.ATTRIBUTE1 ,B.ATTRIBUTE2 ,B.ATTRIBUTE3 ,B.ATTRIBUTE4 ,B.ATTRIBUTE5 ,B.ATTRIBUTE6 ,B.ATTRIBUTE7 ,B.ATTRIBUTE8 ,B.ATTRIBUTE9 ,B.ATTRIBUTE10 ,B.ATTRIBUTE11 ,B.ATTRIBUTE12 ,B.ATTRIBUTE13 ,B.ATTRIBUTE14 ,B.ATTRIBUTE15 ,B.RECOVERY_TYPE_ID ,B.END_DATE ,B.CREATED_BY ,B.CREATION_DATE ,T.RECOVERY_TYPE_NAME ,T.RECOVERY_TYPE_DESC FROM ZX_RECOVERY_TYPES_TL T, ZX_RECOVERY_TYPES_B B WHERE B.RECOVERY_TYPE_ID = T.RECOVERY_TYPE_ID AND T.LANGUAGE = userenv ( 'LANG') |