Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: GL.GL_JE_HEADERS#

Object Details
Object Name: GL_JE_HEADERS#
Object Type: VIEW
Owner: GL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
JE_HEADER_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LEDGER_ID NUMBER (15) Yes
JE_CATEGORY VARCHAR2 (25) Yes
JE_SOURCE VARCHAR2 (25) Yes
PERIOD_NAME VARCHAR2 (15) Yes
NAME VARCHAR2 (100) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
STATUS VARCHAR2 (1) Yes
DATE_CREATED DATE
Yes
ACCRUAL_REV_FLAG VARCHAR2 (1) Yes
MULTI_BAL_SEG_FLAG VARCHAR2 (1) Yes
ACTUAL_FLAG VARCHAR2 (1) Yes
DEFAULT_EFFECTIVE_DATE DATE
Yes
TAX_STATUS_CODE VARCHAR2 (1) Yes
CONVERSION_FLAG VARCHAR2 (1)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ENCUMBRANCE_TYPE_ID NUMBER (15)
BUDGET_VERSION_ID NUMBER (15)
BALANCED_JE_FLAG VARCHAR2 (1)
BALANCING_SEGMENT_VALUE VARCHAR2 (25)
JE_BATCH_ID NUMBER (15)
FROM_RECURRING_HEADER_ID NUMBER (15)
UNIQUE_DATE VARCHAR2 (30)
EARLIEST_POSTABLE_DATE DATE

POSTED_DATE DATE

ACCRUAL_REV_EFFECTIVE_DATE DATE

ACCRUAL_REV_PERIOD_NAME VARCHAR2 (15)
ACCRUAL_REV_STATUS VARCHAR2 (1)
ACCRUAL_REV_JE_HEADER_ID NUMBER (15)
ACCRUAL_REV_CHANGE_SIGN_FLAG VARCHAR2 (1) Yes
DESCRIPTION VARCHAR2 (240)
CONTROL_TOTAL NUMBER

RUNNING_TOTAL_DR NUMBER

RUNNING_TOTAL_CR NUMBER

RUNNING_TOTAL_ACCOUNTED_DR NUMBER

RUNNING_TOTAL_ACCOUNTED_CR NUMBER

CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

EXTERNAL_REFERENCE VARCHAR2 (80)
PARENT_JE_HEADER_ID NUMBER (15)
REVERSED_JE_HEADER_ID NUMBER (15)
ORIGINATING_BAL_SEG_VALUE VARCHAR2 (25)
INTERCOMPANY_MODE NUMBER (15)
DR_BAL_SEG_VALUE VARCHAR2 (25)
CR_BAL_SEG_VALUE VARCHAR2 (25)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
CONTEXT VARCHAR2 (150)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
CONTEXT2 VARCHAR2 (150)
DOC_SEQUENCE_ID NUMBER

DOC_SEQUENCE_VALUE NUMBER

JGZZ_RECON_CONTEXT VARCHAR2 (30)
JGZZ_RECON_REF VARCHAR2 (240)
REFERENCE_DATE DATE

LOCAL_DOC_SEQUENCE_ID NUMBER

LOCAL_DOC_SEQUENCE_VALUE NUMBER

DISPLAY_ALC_JOURNAL_FLAG VARCHAR2 (1)
JE_FROM_SLA_FLAG VARCHAR2 (1)
POSTING_ACCT_SEQ_VERSION_ID NUMBER

POSTING_ACCT_SEQ_ASSIGN_ID NUMBER

POSTING_ACCT_SEQ_VALUE NUMBER

CLOSE_ACCT_SEQ_VERSION_ID NUMBER

CLOSE_ACCT_SEQ_ASSIGN_ID NUMBER

CLOSE_ACCT_SEQ_VALUE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT JE_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LEDGER_ID
,      JE_CATEGORY
,      JE_SOURCE
,      PERIOD_NAME
,      NAME
,      CURRENCY_CODE
,      STATUS
,      DATE_CREATED
,      ACCRUAL_REV_FLAG
,      MULTI_BAL_SEG_FLAG
,      ACTUAL_FLAG
,      DEFAULT_EFFECTIVE_DATE
,      TAX_STATUS_CODE
,      CONVERSION_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ENCUMBRANCE_TYPE_ID
,      BUDGET_VERSION_ID
,      BALANCED_JE_FLAG
,      BALANCING_SEGMENT_VALUE
,      JE_BATCH_ID
,      FROM_RECURRING_HEADER_ID
,      UNIQUE_DATE
,      EARLIEST_POSTABLE_DATE
,      POSTED_DATE
,      ACCRUAL_REV_EFFECTIVE_DATE
,      ACCRUAL_REV_PERIOD_NAME
,      ACCRUAL_REV_STATUS
,      ACCRUAL_REV_JE_HEADER_ID
,      ACCRUAL_REV_CHANGE_SIGN_FLAG
,      DESCRIPTION
,      CONTROL_TOTAL
,      RUNNING_TOTAL_DR
,      RUNNING_TOTAL_CR
,      RUNNING_TOTAL_ACCOUNTED_DR
,      RUNNING_TOTAL_ACCOUNTED_CR
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      EXTERNAL_REFERENCE
,      PARENT_JE_HEADER_ID
,      REVERSED_JE_HEADER_ID
,      ORIGINATING_BAL_SEG_VALUE
,      INTERCOMPANY_MODE
,      DR_BAL_SEG_VALUE
,      CR_BAL_SEG_VALUE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      USSGL_TRANSACTION_CODE
,      CONTEXT2
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      JGZZ_RECON_CONTEXT
,      JGZZ_RECON_REF
,      REFERENCE_DATE
,      LOCAL_DOC_SEQUENCE_ID
,      LOCAL_DOC_SEQUENCE_VALUE
,      DISPLAY_ALC_JOURNAL_FLAG
,      JE_FROM_SLA_FLAG
,      POSTING_ACCT_SEQ_VERSION_ID
,      POSTING_ACCT_SEQ_ASSIGN_ID
,      POSTING_ACCT_SEQ_VALUE
,      CLOSE_ACCT_SEQ_VERSION_ID
,      CLOSE_ACCT_SEQ_ASSIGN_ID
,      CLOSE_ACCT_SEQ_VALUE
FROM GL.GL_JE_HEADERS#;

Dependencies

[top of page]

GL.GL_JE_HEADERS# references the following:

SchemaGL
TableGL_JE_HEADERS
GL.GL_JE_HEADERS# is referenced by following:

SchemaAPPS
SynonymGL_JE_HEADERS