View: IGC_CBC_JE_LINES_V

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGC_CBC_JE_LINES_V

View Text

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 (+)

Columns