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.IGC_CBC_DETAIL_BAL_V

Source

View Text - Preformatted


SELECT GLSOB.CURRENCY_CODE CURRENCY_CODE, CBC.SET_OF_BOOKS_ID, CBC.code_combination_id, CBC.AMOUNT_TYPE, (CBC.ENTERED_DR) FUNCTIONAL_PERIOD_NET_DR, (CBC.ENTERED_CR) FUNCTIONAL_PERIOD_NET_CR, (CBC.PERIOD_NAME) PERIOD_NAME, (CBC.PERIOD_YEAR) PERIOD_YEAR, (CBC.PERIOD_NUM) PERIOD_NUM, (CBC.QUARTER_NUM) QUARTER_NUM, CBC.ACTUAL_FLAG, L1.DESCRIPTION SHOW_ACTUAL_FLAG, CBC.ENCUMBRANCE_TYPE_ID, ET.ENCUMBRANCE_TYPE, CBC.BUDGET_VERSION_ID, GLBV.BUDGET_NAME, GLAH.TEMPLATE_ID, GLST.TEMPLATE_NAME, CBC.QTD_BALANCE, CBC.YTD_BALANCE, CBC.PTD_BALANCE FROM IGC_CBC_JE_LINES_BAL_ALL_V CBC, GL_ACCOUNT_HIERARCHIES GLAH, GL_SETS_OF_BOOKS GLSOB, GL_ENCUMBRANCE_TYPES ET, GL_BUDGET_VERSIONS GLBV, GL_SUMMARY_TEMPLATES GLST, GL_LOOKUPS L1 WHERE (CBC.SET_OF_BOOKS_ID = GLAH.LEDGER_ID (+) AND CBC.CODE_COMBINATION_ID=GLAH.DETAIL_CODE_COMBINATION_ID (+) ) AND CBC.SET_OF_BOOKS_ID=GLSOB.SET_OF_BOOKS_ID AND CBC.ENCUMBRANCE_TYPE_ID=ET.ENCUMBRANCE_TYPE_ID (+) AND CBC.BUDGET_VERSION_ID =GLBV.BUDGET_VERSION_ID (+) AND GLAH.TEMPLATE_ID = GLST.TEMPLATE_ID (+) AND L1.LOOKUP_TYPE(+) ='BATCH_TYPE' AND L1.LOOKUP_CODE(+) = CBC.ACTUAL_FLAG

View Text - HTML Formatted

SELECT GLSOB.CURRENCY_CODE CURRENCY_CODE
, CBC.SET_OF_BOOKS_ID
, CBC.CODE_COMBINATION_ID
, CBC.AMOUNT_TYPE
, (CBC.ENTERED_DR) FUNCTIONAL_PERIOD_NET_DR
, (CBC.ENTERED_CR) FUNCTIONAL_PERIOD_NET_CR
, (CBC.PERIOD_NAME) PERIOD_NAME
, (CBC.PERIOD_YEAR) PERIOD_YEAR
, (CBC.PERIOD_NUM) PERIOD_NUM
, (CBC.QUARTER_NUM) QUARTER_NUM
, CBC.ACTUAL_FLAG
, L1.DESCRIPTION SHOW_ACTUAL_FLAG
, CBC.ENCUMBRANCE_TYPE_ID
, ET.ENCUMBRANCE_TYPE
, CBC.BUDGET_VERSION_ID
, GLBV.BUDGET_NAME
, GLAH.TEMPLATE_ID
, GLST.TEMPLATE_NAME
, CBC.QTD_BALANCE
, CBC.YTD_BALANCE
, CBC.PTD_BALANCE
FROM IGC_CBC_JE_LINES_BAL_ALL_V CBC
, GL_ACCOUNT_HIERARCHIES GLAH
, GL_SETS_OF_BOOKS GLSOB
, GL_ENCUMBRANCE_TYPES ET
, GL_BUDGET_VERSIONS GLBV
, GL_SUMMARY_TEMPLATES GLST
, GL_LOOKUPS L1
WHERE (CBC.SET_OF_BOOKS_ID = GLAH.LEDGER_ID (+)
AND CBC.CODE_COMBINATION_ID=GLAH.DETAIL_CODE_COMBINATION_ID (+) )
AND CBC.SET_OF_BOOKS_ID=GLSOB.SET_OF_BOOKS_ID
AND CBC.ENCUMBRANCE_TYPE_ID=ET.ENCUMBRANCE_TYPE_ID (+)
AND CBC.BUDGET_VERSION_ID =GLBV.BUDGET_VERSION_ID (+)
AND GLAH.TEMPLATE_ID = GLST.TEMPLATE_ID (+)
AND L1.LOOKUP_TYPE(+) ='BATCH_TYPE'
AND L1.LOOKUP_CODE(+) = CBC.ACTUAL_FLAG