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