eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGCFV_CBC_MC_JOURNAL_BATCHES

Source

View Text - Preformatted


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

View Text - HTML Formatted

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