VIEW: APPS.IGC_CBC_SUMMARY_BAL_V

Source

View Text - Preformatted

SELECT GLSOB.CURRENCY_CODE CURRENCY_CODE, CBC.SET_OF_BOOKS_ID, GLAH.SUMMARY_CODE_COMBINATION_ID code_combination_id, SUM(CBC.ENTERED_DR) FUNCTIONAL_PERIOD_NET_DR, SUM(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, SUM(CBC.QTD_BALANCE) QTD_BALANCE, SUM(CBC.YTD_BALANCE) YTD_BALANCE, SUM(CBC.PTD_BALANCE) 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 (GLAH.LEDGER_ID = CBC.SET_OF_BOOKS_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 GROUP BY CBC.SET_OF_BOOKS_ID,GLAH.SUMMARY_CODE_COMBINATION_ID , CBC.BUDGET_VERSION_ID,GLAH.TEMPLATE_ID, GLSOB.CURRENCY_CODE,CBC.PERIOD_NAME,CBC.PERIOD_YEAR, CBC.PERIOD_NUM,CBC.QUARTER_NUM,CBC.ACTUAL_FLAG, L1.DESCRIPTION, CBC.ENCUMBRANCE_TYPE_ID, ET.ENCUMBRANCE_TYPE, GLBV.BUDGET_NAME, GLST.TEMPLATE_NAME

View Text - HTML Formatted

SELECT GLSOB.CURRENCY_CODE CURRENCY_CODE
, CBC.SET_OF_BOOKS_ID
, GLAH.SUMMARY_CODE_COMBINATION_ID CODE_COMBINATION_ID
, SUM(CBC.ENTERED_DR) FUNCTIONAL_PERIOD_NET_DR
, SUM(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
, SUM(CBC.QTD_BALANCE) QTD_BALANCE
, SUM(CBC.YTD_BALANCE) YTD_BALANCE
, SUM(CBC.PTD_BALANCE) 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 (GLAH.LEDGER_ID = CBC.SET_OF_BOOKS_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 GROUP BY CBC.SET_OF_BOOKS_ID
, GLAH.SUMMARY_CODE_COMBINATION_ID
, CBC.BUDGET_VERSION_ID
, GLAH.TEMPLATE_ID
, GLSOB.CURRENCY_CODE
, CBC.PERIOD_NAME
, CBC.PERIOD_YEAR
, CBC.PERIOD_NUM
, CBC.QUARTER_NUM
, CBC.ACTUAL_FLAG
, L1.DESCRIPTION
, CBC.ENCUMBRANCE_TYPE_ID
, ET.ENCUMBRANCE_TYPE
, GLBV.BUDGET_NAME
, GLST.TEMPLATE_NAME