GL_JE_SOURCES

Details

Schema: FUSION
Object owner: GL
Object type: VIEW

Columns

Name
ROW_ID JE_SOURCE_NAME LANGUAGE SOURCE_LANG LAST_UPDATE_DATE LAST_UPDATED_BY OVERRIDE_EDITS_FLAG USER_JE_SOURCE_NAME JE_SOURCE_KEY JOURNAL_REFERENCE_FLAG JOURNAL_APPROVAL_FLAG IMPORT_USING_KEY_FLAG EFFECTIVE_DATE_RULE_CODE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN DESCRIPTION ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_CATEGORY OBJECT_VERSION_NUMBER SINGLE_CURRENCY_JOURNAL_FLAG XLA_APPROVAL_FLAG

Name

ROW_ID

JE_SOURCE_NAME

LANGUAGE

SOURCE_LANG

LAST_UPDATE_DATE

LAST_UPDATED_BY

OVERRIDE_EDITS_FLAG

USER_JE_SOURCE_NAME

JE_SOURCE_KEY

JOURNAL_REFERENCE_FLAG

JOURNAL_APPROVAL_FLAG

IMPORT_USING_KEY_FLAG

EFFECTIVE_DATE_RULE_CODE

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

DESCRIPTION

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_CATEGORY

OBJECT_VERSION_NUMBER

SINGLE_CURRENCY_JOURNAL_FLAG

XLA_APPROVAL_FLAG

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.JE_SOURCE_NAME JE_SOURCE_NAME, TL.LANGUAGE LANGUAGE, TL.SOURCE_LANG SOURCE_LANG, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.OVERRIDE_EDITS_FLAG OVERRIDE_EDITS_FLAG, TL.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME, B.JE_SOURCE_KEY JE_SOURCE_KEY, B.JOURNAL_REFERENCE_FLAG JOURNAL_REFERENCE_FLAG, B.JOURNAL_APPROVAL_FLAG JOURNAL_APPROVAL_FLAG, B.IMPORT_USING_KEY_FLAG IMPORT_USING_KEY_FLAG, B.EFFECTIVE_DATE_RULE_CODE EFFECTIVE_DATE_RULE_CODE, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TL.DESCRIPTION DESCRIPTION, B.ATTRIBUTE1 ATTRIBUTE1, B.ATTRIBUTE2 ATTRIBUTE2, B.ATTRIBUTE3 ATTRIBUTE3, B.ATTRIBUTE4 ATTRIBUTE4, B.ATTRIBUTE5 ATTRIBUTE5, B.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, B.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.SINGLE_CURRENCY_JOURNAL_FLAG, B.XLA_APPROVAL_FLAG FROM GL_JE_SOURCES_B B, GL_JE_SOURCES_TL TL WHERE LANGUAGE = USERENV('LANG') AND B.JE_SOURCE_NAME = TL.JE_SOURCE_NAME

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.JE_SOURCE_NAME JE_SOURCE_NAME,

TL.LANGUAGE LANGUAGE,

TL.SOURCE_LANG SOURCE_LANG,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.OVERRIDE_EDITS_FLAG OVERRIDE_EDITS_FLAG,

TL.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME,

B.JE_SOURCE_KEY JE_SOURCE_KEY,

B.JOURNAL_REFERENCE_FLAG JOURNAL_REFERENCE_FLAG,

B.JOURNAL_APPROVAL_FLAG JOURNAL_APPROVAL_FLAG,

B.IMPORT_USING_KEY_FLAG IMPORT_USING_KEY_FLAG,

B.EFFECTIVE_DATE_RULE_CODE EFFECTIVE_DATE_RULE_CODE,

B.CREATION_DATE CREATION_DATE,

B.CREATED_BY CREATED_BY,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

TL.DESCRIPTION DESCRIPTION,

B.ATTRIBUTE1 ATTRIBUTE1,

B.ATTRIBUTE2 ATTRIBUTE2,

B.ATTRIBUTE3 ATTRIBUTE3,

B.ATTRIBUTE4 ATTRIBUTE4,

B.ATTRIBUTE5 ATTRIBUTE5,

B.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

B.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

B.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

B.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

B.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

B.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

B.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

B.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

B.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

B.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.SINGLE_CURRENCY_JOURNAL_FLAG,

B.XLA_APPROVAL_FLAG

FROM

GL_JE_SOURCES_B B,

GL_JE_SOURCES_TL TL

WHERE

LANGUAGE = USERENV('LANG')

AND B.JE_SOURCE_NAME = TL.JE_SOURCE_NAME