Product: | IGC - Contract Commitment |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGCBV_CBC_MC_JOURNAL_BATCHES |
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
, IGCMJB.RUNNING_TOTAL_DR RUNNING_TOTAL_DR
, IGCMJB.RUNNING_TOTAL_CR RUNNING_TOTAL_CR
, IGCMJB.REPORTING_CURRENCY_CODE CURRENCY_CODE
, IGCMJB.CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, IGCMJB.CONVERSION_DATE CURRENCY_CONVERSION_DATE
, IGCMJB.CONVERSION_RATE CURRENCY_CONVERSION_RATE
, IGC_CBCJEB.CC_HEADER_ID CONTRACT_COMMITMENT_ID
, IGCMJB.CBC_JE_BATCH_ID BATCH_ID
, IGCMJB.REPORTING_SET_OF_BOOKS_ID SET_OF_BOOKS_ID
FROM IGC_CBC_MC_JE_BATCHES IGCMJB
, GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS
, IGC_CBC_JE_BATCHES IGC_CBCJEB
WHERE IGCMJB.CBC_JE_BATCH_ID=IGC_CBCJEB.CBC_JE_BATCH_ID
AND IGCMJB.REPORTING_SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID WITH READ ONLY