Product: | IGC - Contract Commitment |
---|---|
Description: | View based on je_lines_bal_all view for Account Inquiry Summaryl Balances block |
Implementation/DBA Data: | APPS.IGC_CBC_SUMMARY_BAL_V |
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.SET_OF_BOOKS_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