eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GL_JE_BATCHES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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