View: GL_BUDGET_DETAIL_BALANCES_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_BUDGET_DETAIL_BALANCES_V

View Text

SELECT /*+ ORDERED USE_NL(A B) INDEX(A GL_ACCOUNT_HIERARCHIES_U1) INDEX(B GL_BALANCES_N1) */ B.LEDGER_ID LEDGER_ID
, B.CODE_COMBINATION_ID CODE_COMBINATION_ID
, A.SUMMARY_CODE_COMBINATION_ID SUMMARY_CODE_COMBINATION_ID
, B.CURRENCY_CODE CURRENCY_CODE
, B.PERIOD_NAME PERIOD_NAME
, B.BUDGET_VERSION_ID BUDGET_VERSION_ID
, B.TRANSLATED_FLAG TRANSLATED_FLAG
, B.REVALUATION_STATUS REVALUATION_STATUS
, B.PERIOD_YEAR PERIOD_YEAR
, B.PERIOD_NUM PERIOD_NUM
, B.PERIOD_TYPE PERIOD_TYPE
, (NVL(B.PERIOD_NET_DR
, 0) - NVL(B.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PERIOD_NET_AMOUNT
, (NVL(B.BEGIN_BALANCE_DR
, 0) - NVL(B.BEGIN_BALANCE_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR BEGIN_BALANCE_AMOUNT
, (NVL(B.QUARTER_TO_DATE_DR
, 0) - NVL(B.QUARTER_TO_DATE_CR
, 0)) + (NVL(B.PERIOD_NET_DR
, 0) - NVL(B.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR QUARTER_TO_DATE_AMOUNT
, (NVL(B.PROJECT_TO_DATE_DR
, 0) - NVL(B.PROJECT_TO_DATE_CR
, 0)) + (NVL(B.PERIOD_NET_DR
, 0) - NVL(B.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR PROJECT_TO_DATE_AMOUNT
, (NVL(B.BEGIN_BALANCE_DR
, 0) - NVL(B.BEGIN_BALANCE_CR
, 0) + NVL(B.PERIOD_NET_DR
, 0) - NVL(B.PERIOD_NET_CR
, 0)) / BUDGET_INQUIRY_PKG.GET_FACTOR YEAR_TO_DATE_AMOUNT
, A.ROWID ROW_ID
FROM GL_ACCOUNT_HIERARCHIES A
, GL_BALANCES B
WHERE B.ACTUAL_FLAG = 'B' AND B.TEMPLATE_ID IS NULL AND NVL(B.TRANSLATED_FLAG
, 'X') NOT IN ('Y'
, 'N') AND B.LEDGER_ID = A.LEDGER_ID AND B.CODE_COMBINATION_ID = A.DETAIL_CODE_COMBINATION_ID

Columns