[Home] [Help] [Dependency Information]

VIEW: APPS.GL_JE_JOURNAL_LINES_V

Object Details

Object Name:	GL_JE_JOURNAL_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GL_JE_JOURNAL_LINES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT BATCH_ROW_ID
,      JE_BATCH_ID
,      LEDGER_ID
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      EFFECTIVE_PERIOD_NUM
,      ACTUAL_FLAG
,      BATCH_STATUS
,      BUDGETARY_CONTROL_STATUS
,      BATCH_NAME
,      BATCH_DESCRIPTION
,      BATCH_DATE_CREATED
,      BATCH_POSTED_DATE
,      BATCH_USSGL_TRANSACTION_CODE
,      BATCH_CONTROL_TOTAL
,      BATCH_RUNNING_TOTAL_DR
,      BATCH_RUNNING_TOTAL_CR
,      BATCH_RUN_TOTAL_ACCOUNTED_DR
,      BATCH_RUN_TOTAL_ACCOUNTED_CR
,      BATCH_STATUS_VERIFIED
,      BATCH_EFFECTIVE_DATE
,      BATCH_STATUS_RESET_FLAG
,      BATCH_UNIQUE_DATE
,      BATCH_EARLIEST_POSTABLE_DATE
,      PACKET_ID
,      UNRESERVATION_PACKET_ID
,      POSTING_RUN_ID
,      REQUEST_ID
,      BATCH_ATTRIBUTE1
,      BATCH_ATTRIBUTE2
,      BATCH_ATTRIBUTE3
,      BATCH_ATTRIBUTE4
,      BATCH_ATTRIBUTE5
,      BATCH_ATTRIBUTE6
,      BATCH_ATTRIBUTE7
,      BATCH_ATTRIBUTE8
,      BATCH_ATTRIBUTE9
,      BATCH_ATTRIBUTE10
,      BATCH_CONTEXT
,      BATCH_CONTEXT2
,      BATCH_CREATION_DATE
,      BATCH_CREATED_BY
,      BATCH_LAST_UPDATE_DATE
,      BATCH_LAST_UPDATED_BY
,      BATCH_LAST_UPDATE_LOGIN
,      HEADER_ROW_ID
,      JE_HEADER_ID
,      HEADER_NAME
,      JE_SOURCE
,      JE_CATEGORY
,      HEADER_DESCRIPTION
,      EXTERNAL_REFERENCE
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      ENCUMBRANCE_TYPE_ID
,      BUDGET_VERSION_ID
,      HEADER_EFFECTIVE_DATE
,      HEADER_USSGL_TRANSACTION_CODE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      ACCRUAL_REV_FLAG
,      ACCRUAL_REV_PERIOD_NAME
,      ACCRUAL_REV_STATUS
,      HEADER_CONTROL_TOTAL
,      HEADER_RUNNING_TOTAL_DR
,      HEADER_RUNNING_TOTAL_CR
,      HEADER_RUN_TOTAL_ACCOUNTED_DR
,      HEADER_RUN_TOTAL_ACCOUNTED_CR
,      HEADER_STATUS
,      HEADER_DATE_CREATED
,      MULTI_BAL_SEG_FLAG
,      CONVERSION_FLAG
,      BALANCED_JE_FLAG
,      BALANCING_SEGMENT_VALUE
,      FROM_RECURRING_HEADER_ID
,      HEADER_UNIQUE_DATE
,      HEADER_EARLIEST_POSTABLE_DATE
,      HEADER_POSTED_DATE
,      ACCRUAL_REV_EFFECTIVE_DATE
,      ACCRUAL_REV_JE_HEADER_ID
,      ACCRUAL_REV_CHANGE_SIGN_FLAG
,      PARENT_JE_HEADER_ID
,      HEADER_ATTRIBUTE1
,      HEADER_ATTRIBUTE2
,      HEADER_ATTRIBUTE3
,      HEADER_ATTRIBUTE4
,      HEADER_ATTRIBUTE5
,      HEADER_ATTRIBUTE6
,      HEADER_ATTRIBUTE7
,      HEADER_ATTRIBUTE8
,      HEADER_ATTRIBUTE9
,      HEADER_ATTRIBUTE10
,      HEADER_CONTEXT
,      HEADER_CONTEXT2
,      HEADER_CREATION_DATE
,      HEADER_CREATED_BY
,      HEADER_LAST_UPDATE_DATE
,      HEADER_LAST_UPDATED_BY
,      HEADER_LAST_UPDATE_LOGIN
,      ROW_ID
,      LINE_LEDGER_ID
,      LINE_JE_LINE_NUM
,      LINE_CODE_COMBINATION_ID
,      LINE_PERIOD_NAME
,      LINE_EFFECTIVE_DATE
,      LINE_ENTERED_DR_NUM
,      LINE_ENTERED_CR_NUM
,      LINE_ENTERED_DR
,      LINE_ENTERED_CR
,      LINE_ACCOUNTED_DR
,      LINE_ACCOUNTED_CR
,      LINE_DESCRIPTION
,      LINE_REFERENCE_1
,      LINE_REFERENCE_2
,      LINE_REFERENCE_3
,      LINE_REFERENCE_4
,      LINE_REFERENCE_5
,      LINE_REFERENCE_6
,      LINE_REFERENCE_7
,      LINE_REFERENCE_8
,      LINE_REFERENCE_9
,      LINE_REFERENCE_10
,      LINE_ATTRIBUTE1
,      LINE_ATTRIBUTE2
,      LINE_ATTRIBUTE3
,      LINE_ATTRIBUTE4
,      LINE_ATTRIBUTE5
,      LINE_ATTRIBUTE6
,      LINE_ATTRIBUTE7
,      LINE_ATTRIBUTE8
,      LINE_ATTRIBUTE9
,      LINE_ATTRIBUTE10
,      LINE_ATTRIBUTE11
,      LINE_ATTRIBUTE12
,      LINE_ATTRIBUTE13
,      LINE_ATTRIBUTE14
,      LINE_ATTRIBUTE15
,      LINE_ATTRIBUTE16
,      LINE_ATTRIBUTE17
,      LINE_ATTRIBUTE18
,      LINE_ATTRIBUTE19
,      LINE_ATTRIBUTE20
,      LINE_CONTEXT
,      LINE_CONTEXT2
,      LINE_CONTEXT3
,      LINE_CONTEXT4
,      LINE_INVOICE_DATE
,      LINE_TAX_CODE
,      LINE_INVOICE_IDENTIFIER
,      LINE_INVOICE_AMOUNT
,      LINE_NO1
,      LINE_STAT_AMOUNT
,      LINE_IGNORE_RATE_FLAG
,      LINE_USSGL_TRANSACTION_CODE
,      SUBLEDGER_DOC_SEQUENCE_ID
,      SUBLEDGER_DOC_SEQUENCE_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LEDGER_NAME
,      LEDGER_CURRENCY
FROM APPS.GL_JE_JOURNAL_LINES_V;

Dependencies

[top of page]

APPS

GLR03300_PKG - show dependent code

GL_JE_BATCHES

GL_JE_HEADERS

GL_JE_LINES

GL_LEDGER_RELATIONSHIPS

GL_PERIOD_STATUSES

APPS.GL_JE_JOURNAL_LINES_V is not referenced by any database object