VIEW: APPS.ZX_RECOVERY_TYPES_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID ,B.START_DATE ,B.PROGRAM_APPLICATION_ID ,B.PROGRAM_ID ,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') 
   

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.START_DATE
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, 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')