ZX_REPORTING_CODES_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID REPORTING_CODE_ID REPORTING_CODE_CHAR_VALUE REPORTING_CODE_DATE_VALUE REPORTING_CODE_NUM_VALUE REPORTING_TYPE_ID EXCEPTION_CODE EFFECTIVE_FROM EFFECTIVE_TO 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_CODE_NAME VALUE_TYPE_CODE SIGN_FLAG

Query

SQL_Statement

select B.ROWID ROW_ID, B.REPORTING_CODE_ID, B.REPORTING_CODE_CHAR_VALUE, B.REPORTING_CODE_DATE_VALUE, B.REPORTING_CODE_NUM_VALUE, B.REPORTING_TYPE_ID, B.EXCEPTION_CODE, B.EFFECTIVE_FROM, B.EFFECTIVE_TO, 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_CODE_NAME, B.VALUE_TYPE_CODE, B.SIGN_FLAG from ZX_REPORTING_CODES_TL T, ZX_REPORTING_CODES_B B where B.REPORTING_CODE_ID = T.REPORTING_CODE_ID and T.LANGUAGE = userenv('LANG')