Product: | IGC - Contract Commitment |
---|---|
Description: | View based on je_lines_bal_all view for Account Inquiry Balances block |
Implementation/DBA Data: | APPS.IGC_CBC_ALL_BAL_V |
SELECT SUMM.CURRENCY_CODE
, SUMM.SET_OF_BOOKS_ID
, SUMM.CODE_COMBINATION_ID
, SUMM.FUNCTIONAL_PERIOD_NET_DR
, SUMM.FUNCTIONAL_PERIOD_NET_CR
, SUMM.PERIOD_NAME
, SUMM.PERIOD_YEAR
, SUMM.PERIOD_NUM
, SUMM.QUARTER_NUM
, SUMM.ACTUAL_FLAG
, SUMM.SHOW_ACTUAL_FLAG
, SUMM.ENCUMBRANCE_TYPE_ID
, SUMM.ENCUMBRANCE_TYPE
, SUMM.BUDGET_VERSION_ID
, SUMM.BUDGET_NAME
, SUMM.TEMPLATE_ID
, SUMM.TEMPLATE_NAME
, SUMM.QTD_BALANCE
, SUMM.YTD_BALANCE
, SUMM.PTD_BALANCE
FROM IGC_CBC_SUMMARY_BAL_V SUMM UNION SELECT GLSOB.CURRENCY_CODE
, CBC.SET_OF_BOOKS_ID
, CBC.CODE_COMBINATION_ID
, CBC.ENTERED_DR FUNCTIONAL_PERIOD_NET_DR
, CBC.ENTERED_CR FUNCTIONAL_PERIOD_NET_CR
, CBC.PERIOD_NAME
, CBC.PERIOD_YEAR
, CBC.PERIOD_NUM
, CBC.QUARTER_NUM
, CBC.ACTUAL_FLAG
, L1.DESCRIPTION SHOW_ACTUAL_FLAG
, CBC.ENCUMBRANCE_TYPE_ID
, ET.ENCUMBRANCE_TYPE
, CBC.BUDGET_VERSION_ID
, GLBV.BUDGET_NAME
, -1 TEMPLATE_ID
, ' ' TEMPLATE_NAME
, CBC.QTD_BALANCE
, CBC.YTD_BALANCE
, CBC.PTD_BALANCE
FROM IGC_CBC_JE_LINES_BAL_ALL_V CBC
, GL_SETS_OF_BOOKS GLSOB
, GL_ENCUMBRANCE_TYPES ET
, GL_BUDGET_VERSIONS GLBV
, GL_LOOKUPS L1
WHERE 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 L1.LOOKUP_TYPE(+) ='BATCH_TYPE'
AND L1.LOOKUP_CODE(+) = CBC.ACTUAL_FLAG