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')