View: GL_JE_BATCHES_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_JE_BATCHES_V

View Text

SELECT B.ROWID ROW_ID
, B.JE_BATCH_ID JE_BATCH_ID
, B.NAME NAME
, B.DEFAULT_PERIOD_NAME DEFAULT_PERIOD_NAME
, B.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, B.PERIOD_SET_NAME PERIOD_SET_NAME
, B.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
, PER.START_DATE START_DATE
, PER.END_DATE END_DATE
, PER.PERIOD_YEAR PERIOD_YEAR
, PER.PERIOD_NUM PERIOD_NUM
, L3.DESCRIPTION SHOW_ACTUAL_FLAG
, B.ACTUAL_FLAG ACTUAL_FLAG
, B.DESCRIPTION DESCRIPTION
, B.STATUS STATUS
, L.DESCRIPTION SHOW_STATUS
, B.BUDGETARY_CONTROL_STATUS BUDGETARY_CONTROL_STATUS
, L2.MEANING SHOW_BC_STATUS
, TRUNC(B.DATE_CREATED) DATE_CREATED
, TRUNC(B.POSTED_DATE) POSTED_DATE
, B.POSTED_BY POSTED_BY
, DECODE(B.POSTED_BY
, NULL
, NULL
, (SELECT USER_NAME
FROM FND_USER
WHERE USER_ID = B.POSTED_BY)) POSTED_BY_NAME
, B.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, B.CONTROL_TOTAL CONTROL_TOTAL
, B.RUNNING_TOTAL_DR RUNNING_TOTAL_DR
, B.RUNNING_TOTAL_CR RUNNING_TOTAL_CR
, B.RUNNING_TOTAL_ACCOUNTED_DR RUNNING_TOTAL_ACCOUNTED_DR
, B.RUNNING_TOTAL_ACCOUNTED_CR RUNNING_TOTAL_ACCOUNTED_CR
, B.AVERAGE_JOURNAL_FLAG AVERAGE_JOURNAL_FLAG
, B.ORG_ID ORG_ID
, B.STATUS_VERIFIED STATUS_VERIFIED
, B.DEFAULT_EFFECTIVE_DATE DEFAULT_EFFECTIVE_DATE
, B.STATUS_RESET_FLAG STATUS_RESET_FLAG
, B.UNIQUE_DATE UNIQUE_DATE
, B.EARLIEST_POSTABLE_DATE EARLIEST_POSTABLE_DATE
, B.PACKET_ID PACKET_ID
, B.UNRESERVATION_PACKET_ID UNRESERVATION_PACKET_ID
, B.POSTING_RUN_ID POSTING_RUN_ID
, B.REQUEST_ID REQUEST_ID
, B.APPROVAL_STATUS_CODE APPROVAL_STATUS_CODE
, B.ATTRIBUTE1 ATTRIBUTE1
, B.ATTRIBUTE2 ATTRIBUTE2
, B.ATTRIBUTE3 ATTRIBUTE3
, B.ATTRIBUTE4 ATTRIBUTE4
, B.ATTRIBUTE5 ATTRIBUTE5
, B.ATTRIBUTE6 ATTRIBUTE6
, B.ATTRIBUTE7 ATTRIBUTE7
, B.ATTRIBUTE8 ATTRIBUTE8
, B.ATTRIBUTE9 ATTRIBUTE9
, B.ATTRIBUTE10 ATTRIBUTE10
, B.CONTEXT CONTEXT
, B.CONTEXT2 CONTEXT2
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, B.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, B.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, B.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, B.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, B.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, B.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, B.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, B.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, B.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, B.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, B.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, B.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, B.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, B.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, B.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, B.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, B.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, B.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, B.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, B.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
FROM GL_JE_BATCHES B
, GL_PERIODS PER
, GL_LOOKUPS L3
, GL_LOOKUPS L2
, GL_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'MJE_BATCH_STATUS'
AND L.LOOKUP_CODE = SUBSTR(B.STATUS
, 1
, 1)
AND L2.LOOKUP_TYPE = 'JE_BATCH_BC_STATUS'
AND L2.LOOKUP_CODE = B.BUDGETARY_CONTROL_STATUS
AND L3.LOOKUP_TYPE = 'BATCH_TYPE'
AND L3.LOOKUP_CODE = B.ACTUAL_FLAG
AND PER.PERIOD_SET_NAME = B.PERIOD_SET_NAME
AND PER.PERIOD_TYPE = B.ACCOUNTED_PERIOD_TYPE
AND PER.PERIOD_NAME = B.DEFAULT_PERIOD_NAME

Columns