JG_FSCL_DOC_SERIES_VL

Details

• Schema: FUSION

• Object owner: JG

• Object type: VIEW

Columns

Name

ROW_ID FISCAL_DOCUMENT_SERIES_ID SERIES_CODE FISCAL_DOCUMENT_MODEL DELIVERY_NOTE_PRINTING_FORMAT ENABLED_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SERIES_DESCRIPTION

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.FISCAL_DOCUMENT_SERIES_ID, B.SERIES_CODE, B.FISCAL_DOCUMENT_MODEL , B.DELIVERY_NOTE_PRINTING_FORMAT , B.ENABLED_FLAG , 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.ATTRIBUTE_NUMBER1 , B.ATTRIBUTE_NUMBER2 , B.ATTRIBUTE_NUMBER3 , B.ATTRIBUTE_NUMBER4 , B.ATTRIBUTE_NUMBER5 , B.ATTRIBUTE_DATE1 , B.ATTRIBUTE_DATE2 , B.ATTRIBUTE_DATE3 , B.ATTRIBUTE_DATE4 , B.ATTRIBUTE_DATE5 , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , B.OBJECT_VERSION_NUMBER , T.SERIES_DESCRIPTION FROM JG_FSCL_DOC_SERIES_TL T, JG_FSCL_DOC_SERIES_B B WHERE B.FISCAL_DOCUMENT_SERIES_ID = T.FISCAL_DOCUMENT_SERIES_ID AND T.LANGUAGE = USERENV('LANG')