VIEW: APPS.IGC_CBC_JE_LINES_V

Source

View Text - Preformatted

SELECT jel.rowid ROW_ID, jel.cbc_je_batch_id CBC_JE_BATCH_ID, jel.cbc_je_line_num CBC_JE_LINE_NUM, jeb.NAME BATCH_NAME, jeb.EFFECTIVE_DATE BATCH_EFFECTIVE_DATE, jeb.DESCRIPTION BATCH_DESCRIPTION, jeb.RUNNING_TOTAL_DR RUNNING_TOTAL_DR, jeb.RUNNING_TOTAL_CR RUNNING_TOTAL_CR, jel.je_source JE_SOURCE, jel.je_category JE_CATEGORY, jel.currency_code CURRENCY_CODE, jel.actual_flag ACTUAL_FLAG, L.DESCRIPTION SHOW_ACTUAL_FLAG , jel.set_of_books_id SET_OF_BOOKS_ID, jel.encumbrance_type_id ENCUMBRANCE_TYPE_ID, et.encumbrance_type ENCUMBRANCE_TYPE, jel. budget_version_id BUDGET_VERSION_ID, jel.balancing_segment_value BALANCING_SEGMENT_VALUE, jel.detail_summary_code DETAIL_SUMMARY_CODE, jel.code_combination_id CODE_COMBINATION_ID, jel.funds_check_level_code FUNDS_CHECK_LEVEL_CODE, jel.amount_type AMOUNT_TYPE, jel.effective_date EFFECTIVE_DATE, TRUNC(jel.posted_date) POSTED_DATE, jel.period_year PERIOD_YEAR, jel.dr_cr_code DR_CR_CODE, jel.entered_dr ENTERED_DR, jel.entered_cr ENTERED_CR, jel.description DESCRIPTION, jel.budget_type BUDGET_TYPE, jel.period_set_name PERIOD_SET_NAME, jel.period_name PERIOD_NAME, jel.quarter_num QUARTER_NUM, jel.period_num PERIOD_NUM, jel.status STATUS, jel.context CONTEXT, jel.last_update_date LAST_UPDATE_DATE, jel.last_updated_by LAST_UPDATED_BY, jel.last_update_login LAST_UPDATE_LOGIN, jel.creation_date CREATION_DATE, jel.created_by CREATED_BY, jel.reference_1 REFERENCE_1, jel.reference_2 REFERENCE_2, jel.reference_3 REFERENCE_3, jel.reference_4 REFERENCE_4, jel.reference_5 REFERENCE_5, jel.reference_6 REFERENCE_6, jel.reference_7 REFERENCE_7, jel.reference_8 REFERENCE_8, jel.reference_9 REFERENCE_9, jel.reference_10 REFERENCE_10, jel.ATTRIBUTE1 ATTRIBUTE1, jel.ATTRIBUTE2 ATTRIBUTE2, jel.ATTRIBUTE3 ATTRIBUTE3, jel.ATTRIBUTE4 ATTRIBUTE4, jel.ATTRIBUTE5 ATTRIBUTE5, jel.ATTRIBUTE6 ATTRIBUTE6, jel.ATTRIBUTE7 ATTRIBUTE7, jel.ATTRIBUTE8 ATTRIBUTE8, jel.ATTRIBUTE9 ATTRIBUTE9, jel.ATTRIBUTE10 ATTRIBUTE10 FROM igc_cbc_je_lines jel, igc_cbc_je_batches jeb, gl_encumbrance_types et, gl_lookups L WHERE jeb.cbc_je_batch_id = jel.cbc_je_batch_id and l.LOOKUP_TYPE(+) = 'BATCH_TYPE' AND l.LOOKUP_CODE(+) = jel.ACTUAL_FLAG AND jel.encumbrance_type_id = et.encumbrance_type_id (+)

View Text - HTML Formatted

SELECT JEL.ROWID ROW_ID
, JEL.CBC_JE_BATCH_ID CBC_JE_BATCH_ID
, JEL.CBC_JE_LINE_NUM CBC_JE_LINE_NUM
, JEB.NAME BATCH_NAME
, JEB.EFFECTIVE_DATE BATCH_EFFECTIVE_DATE
, JEB.DESCRIPTION BATCH_DESCRIPTION
, JEB.RUNNING_TOTAL_DR RUNNING_TOTAL_DR
, JEB.RUNNING_TOTAL_CR RUNNING_TOTAL_CR
, JEL.JE_SOURCE JE_SOURCE
, JEL.JE_CATEGORY JE_CATEGORY
, JEL.CURRENCY_CODE CURRENCY_CODE
, JEL.ACTUAL_FLAG ACTUAL_FLAG
, L.DESCRIPTION SHOW_ACTUAL_FLAG
, JEL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, JEL.ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, ET.ENCUMBRANCE_TYPE ENCUMBRANCE_TYPE
, JEL. BUDGET_VERSION_ID BUDGET_VERSION_ID
, JEL.BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE
, JEL.DETAIL_SUMMARY_CODE DETAIL_SUMMARY_CODE
, JEL.CODE_COMBINATION_ID CODE_COMBINATION_ID
, JEL.FUNDS_CHECK_LEVEL_CODE FUNDS_CHECK_LEVEL_CODE
, JEL.AMOUNT_TYPE AMOUNT_TYPE
, JEL.EFFECTIVE_DATE EFFECTIVE_DATE
, TRUNC(JEL.POSTED_DATE) POSTED_DATE
, JEL.PERIOD_YEAR PERIOD_YEAR
, JEL.DR_CR_CODE DR_CR_CODE
, JEL.ENTERED_DR ENTERED_DR
, JEL.ENTERED_CR ENTERED_CR
, JEL.DESCRIPTION DESCRIPTION
, JEL.BUDGET_TYPE BUDGET_TYPE
, JEL.PERIOD_SET_NAME PERIOD_SET_NAME
, JEL.PERIOD_NAME PERIOD_NAME
, JEL.QUARTER_NUM QUARTER_NUM
, JEL.PERIOD_NUM PERIOD_NUM
, JEL.STATUS STATUS
, JEL.CONTEXT CONTEXT
, JEL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JEL.LAST_UPDATED_BY LAST_UPDATED_BY
, JEL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JEL.CREATION_DATE CREATION_DATE
, JEL.CREATED_BY CREATED_BY
, JEL.REFERENCE_1 REFERENCE_1
, JEL.REFERENCE_2 REFERENCE_2
, JEL.REFERENCE_3 REFERENCE_3
, JEL.REFERENCE_4 REFERENCE_4
, JEL.REFERENCE_5 REFERENCE_5
, JEL.REFERENCE_6 REFERENCE_6
, JEL.REFERENCE_7 REFERENCE_7
, JEL.REFERENCE_8 REFERENCE_8
, JEL.REFERENCE_9 REFERENCE_9
, JEL.REFERENCE_10 REFERENCE_10
, JEL.ATTRIBUTE1 ATTRIBUTE1
, JEL.ATTRIBUTE2 ATTRIBUTE2
, JEL.ATTRIBUTE3 ATTRIBUTE3
, JEL.ATTRIBUTE4 ATTRIBUTE4
, JEL.ATTRIBUTE5 ATTRIBUTE5
, JEL.ATTRIBUTE6 ATTRIBUTE6
, JEL.ATTRIBUTE7 ATTRIBUTE7
, JEL.ATTRIBUTE8 ATTRIBUTE8
, JEL.ATTRIBUTE9 ATTRIBUTE9
, JEL.ATTRIBUTE10 ATTRIBUTE10
FROM IGC_CBC_JE_LINES JEL
, IGC_CBC_JE_BATCHES JEB
, GL_ENCUMBRANCE_TYPES ET
, GL_LOOKUPS L
WHERE JEB.CBC_JE_BATCH_ID = JEL.CBC_JE_BATCH_ID
AND L.LOOKUP_TYPE(+) = 'BATCH_TYPE'
AND L.LOOKUP_CODE(+) = JEL.ACTUAL_FLAG
AND JEL.ENCUMBRANCE_TYPE_ID = ET.ENCUMBRANCE_TYPE_ID (+)