View: IGCBV_CBC_MC_JOURNAL_LINES

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

View Text

SELECT GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME
, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME
, IGC_CBCJEB.NAME BATCH_NAME
, IGCMJL.CBC_JE_LINE_NUM JOURNAL_LINE_NUMBER
, IGCMJL.ENTERED_DR ENTERED_DR
, IGCMJL.ENTERED_CR ENTERED_CR
, IGCMJL.REPORTING_CURRENCY_CODE CURRENCY_CODE
, IGCMJL.CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, IGCMJL.CONVERSION_DATE CURRENCY_CONVERSION_DATE
, IGCMJL.CONVERSION_RATE CURRENCY_CONVERSION_RATE
, IGCMJL.REPORTING_SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, IGCMJL.CBC_JE_BATCH_ID BATCH_ID
FROM IGC_CBC_MC_JE_LINES IGCMJL
, GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS
, IGC_CBC_JE_LINES IGC_CBCJEL
, IGC_CBC_JE_BATCHES IGC_CBCJEB
WHERE IGCMJL.CBC_JE_LINE_NUM=IGC_CBCJEL.CBC_JE_LINE_NUM
AND IGCMJL.CBC_JE_BATCH_ID=IGC_CBCJEB.CBC_JE_BATCH_ID
AND IGCMJL.REPORTING_SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID WITH READ ONLY

Columns