Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGCFV_CBC_MC_JOURNAL_LINES |
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_BATCHES IGC_CBCJEB
, IGC_CBC_JE_LINES IGC_CBCJEL
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