VIEW: APPS.IGC_CBC_ALL_BAL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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