View: IGC_CBC_DET_BALANCES_V

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGC_CBC_DET_BALANCES_V

View Text

SELECT SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, BUDGET_VERSION_ID
, BUDGET_AMOUNT
, COMM_AMOUNT
, ACT_AMOUNT
, OTH_AMOUNT
, COMM_AMOUNT+ACT_AMOUNT+OTH_AMOUNT TOT_AMOUNT
, BUDGET_AMOUNT-COMM_AMOUNT-ACT_AMOUNT FA_AMOUNT
, SUBSTR(IGC_CBC_INQUIRY_PKG.GET_AMOUNT_TYPE
, 1
, 4) AMOUNT_TYPE
, SUBSTR(IGC_CBC_INQUIRY_PKG.GET_PERIOD_NAME
, 1
, 20) PERIOD_NAME
, SYSDATE LAST_UPDATE_DATE
, -1 LAST_UPDATED_BY
FROM ( SELECT LN.SET_OF_BOOKS_ID
, LN.CODE_COMBINATION_ID
, MAX(NVL( LN.BUDGET_VERSION_ID
, 0)) BUDGET_VERSION_ID
, SUM(DECODE(LN.ACTUAL_FLAG
, 'B'
, (NVL(LN.ENTERED_DR
, 0)-NVL(LN.ENTERED_CR
, 0))
, 0)) BUDGET_AMOUNT
, SUM(DECODE(LN.ACTUAL_FLAG
, 'E'
, DECODE(LN.ENCUMBRANCE_TYPE_ID
, CC_PROV_ENCMBRNC_TYPE_ID
, (NVL(LN.ENTERED_DR
, 0)-NVL(LN.ENTERED_CR
, 0))
, 0)
, 0)) COMM_AMOUNT
, SUM(DECODE(LN.ACTUAL_FLAG
, 'E'
, DECODE(LN.ENCUMBRANCE_TYPE_ID
, CC_CONF_ENCMBRNC_TYPE_ID
, (NVL(LN.ENTERED_DR
, 0)-NVL(LN.ENTERED_CR
, 0))
, 0)
, 0)) ACT_AMOUNT
, SUM(DECODE(LN.ACTUAL_FLAG
, 'E'
, DECODE(LN.ENCUMBRANCE_TYPE_ID
, CC_CONF_ENCMBRNC_TYPE_ID
, 0
, CC_PROV_ENCMBRNC_TYPE_ID
, 0
, (NVL(LN.ENTERED_DR
, 0)-NVL(LN.ENTERED_CR
, 0)))
, 0)) OTH_AMOUNT
FROM IGC_CBC_JE_LINES LN
, IGC_CC_ENCMBRNC_ORG_V
WHERE IGC_CBC_INQUIRY_PKG.CHECK_AMOUNT_TYPE(LN.PERIOD_NAME
, LN.PERIOD_YEAR
, LN.QUARTER_NUM
, LN.PERIOD_NUM
, ACTUAL_FLAG
, BUDGET_VERSION_ID)='T' GROUP BY LN.SET_OF_BOOKS_ID
, LN.CODE_COMBINATION_ID )

Columns