VIEW: APPS.IGCFV_CBC_JOURNAL_BATCHES

Source

View Text - Preformatted

SELECT IGC_CBCJEB.NAME BATCH_NAME, '_LA:BATCH_STATUS:GL_LOOKUPS:BATCH_STATUS:DESCRIPTION' "_LA:BATCH_STATUS", '_LA:ACTUAL_FLAG:GL_LOOKUPS:BATCH_TYPE:DESCRIPTION' "_LA:BALANCE_TYPE", '_LA:BUDGETARY_CONTROL_STATUS:GL_LOOKUPS:JE_BATCH_BC_STATUS:DESCRIPTION' "_LA:APPROVAL_STATUS", '_LA:APPROVAL_STATUS_CODE:GL_LOOKUPS:JE_BATCH_APPROVAL_STATUS:MEANING' "_LA:FUNDS_CHECK_STATUS", IGC_CBCJEB.RUNNING_TOTAL_DR RUNNING_TOTAL_DR, IGC_CBCJEB.RUNNING_TOTAL_CR RUNNING_TOTAL_CR, IGC_CBCJEB.EFFECTIVE_DATE EFFECTIVE_DATE, IGC_CBCJEB.DESCRIPTION DESCRIPTION, IGC_CCH.CC_NUM CONTRACT_COMMITMENT_NUMBER, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME, IGC_CBCJEB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, IGC_CBCJEB.CC_HEADER_ID CONTRACT_COMMITMENT_ID, IGC_CBCJEB.CBC_JE_BATCH_ID JOURNAL_BATCH_ID, IGC_CBCJEB.LAST_UPDATE_DATE LAST_UPDATE_DATE, IGC_CBCJEB.LAST_UPDATED_BY LAST_UPDATED_BY, IGC_CBCJEB.CREATION_DATE CREATION_DATE, IGC_CBCJEB.CREATED_BY CREATED_BY FROM IGC_CBC_JE_BATCHES IGC_CBCJEB,GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS,IGC_CC_HEADERS IGC_CCH WHERE IGC_CBCJEB.SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID AND IGC_CBCJEB.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT IGC_CBCJEB.NAME BATCH_NAME
, '_LA:BATCH_STATUS:GL_LOOKUPS:BATCH_STATUS:DESCRIPTION' "_LA:BATCH_STATUS"
, '_LA:ACTUAL_FLAG:GL_LOOKUPS:BATCH_TYPE:DESCRIPTION' "_LA:BALANCE_TYPE"
, '_LA:BUDGETARY_CONTROL_STATUS:GL_LOOKUPS:JE_BATCH_BC_STATUS:DESCRIPTION' "_LA:APPROVAL_STATUS"
, '_LA:APPROVAL_STATUS_CODE:GL_LOOKUPS:JE_BATCH_APPROVAL_STATUS:MEANING' "_LA:FUNDS_CHECK_STATUS"
, IGC_CBCJEB.RUNNING_TOTAL_DR RUNNING_TOTAL_DR
, IGC_CBCJEB.RUNNING_TOTAL_CR RUNNING_TOTAL_CR
, IGC_CBCJEB.EFFECTIVE_DATE EFFECTIVE_DATE
, IGC_CBCJEB.DESCRIPTION DESCRIPTION
, IGC_CCH.CC_NUM CONTRACT_COMMITMENT_NUMBER
, GL_SETS_OF_BOOKS.NAME SETS_OF_BOOKS_NAME
, GL_SETS_OF_BOOKS.SHORT_NAME SETS_OF_BOOKS_SHORT_NAME
, IGC_CBCJEB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, IGC_CBCJEB.CC_HEADER_ID CONTRACT_COMMITMENT_ID
, IGC_CBCJEB.CBC_JE_BATCH_ID JOURNAL_BATCH_ID
, IGC_CBCJEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IGC_CBCJEB.LAST_UPDATED_BY LAST_UPDATED_BY
, IGC_CBCJEB.CREATION_DATE CREATION_DATE
, IGC_CBCJEB.CREATED_BY CREATED_BY
FROM IGC_CBC_JE_BATCHES IGC_CBCJEB
, GL_SETS_OF_BOOKS GL_SETS_OF_BOOKS
, IGC_CC_HEADERS IGC_CCH
WHERE IGC_CBCJEB.SET_OF_BOOKS_ID=GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID
AND IGC_CBCJEB.CC_HEADER_ID=IGC_CCH.CC_HEADER_ID (+) WITH READ ONLY