ZX_REPORTING_TYPES_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID REPORTING_TYPE_ID REPORTING_TYPE_CODE REPORTING_TYPE_DATATYPE_CODE TAX_REGIME_CODE TAX FORMAT_MASK MIN_LENGTH MAX_LENGTH LEGAL_MESSAGE_FLAG EFFECTIVE_FROM EFFECTIVE_TO HAS_REPORTING_CODES_FLAG OBJECT_VERSION_NUMBER RECORD_TYPE_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID REPORTING_TYPE_NAME COUNTRY_CODE VALIDATION_LEVEL UNIQUENESS_VALIDATION_LEVEL VALIDATION_ROUTINE REGISTRATION_TYPE MODULE_ID

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.REPORTING_TYPE_ID, B.REPORTING_TYPE_CODE, B.REPORTING_TYPE_DATATYPE_CODE, B.TAX_REGIME_CODE, B.TAX, B.FORMAT_MASK, B.MIN_LENGTH, B.MAX_LENGTH, B.LEGAL_MESSAGE_FLAG, B.EFFECTIVE_FROM, B.EFFECTIVE_TO, B.HAS_REPORTING_CODES_FLAG, B.OBJECT_VERSION_NUMBER, B.RECORD_TYPE_CODE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.REQUEST_ID, B.PROGRAM_APP_NAME, B.PROGRAM_NAME, B.PROGRAM_LOGIN_ID, T.REPORTING_TYPE_NAME, B.COUNTRY_CODE, B.VALIDATION_LEVEL, B.UNIQUENESS_VALIDATION_LEVEL, B.VALIDATION_ROUTINE, B.REGISTRATION_TYPE, B.MODULE_ID FROM ZX_REPORTING_TYPES_TL T, ZX_REPORTING_TYPES_B B WHERE B.REPORTING_TYPE_ID = T.REPORTING_TYPE_ID AND T.LANGUAGE = USERENV('LANG')