eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: GL_OASIS_SUMMARY_DATA_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SD.SET_OF_BOOKS_ID
, BK.NAME
, SD.FIN_ITEM_ID
, FI.NAME
, SD.DRILLDOWN_SEGNUM1
, SD.DRILLDOWN_SEGNUM2
, SD.ACTUAL_FLAG
, LK.MEANING
, SD.DRILLDOWN_SEGVAL1
, SD.DRILLDOWN_SEGVAL2
, GL_FLEXFIELDS_PKG.GET_SD_DESCRIPTION_SQL(BK.CHART_OF_ACCOUNTS_ID
, 1
, SD.DRILLDOWN_SEGNUM1
, SD.DRILLDOWN_SEGVAL1)
, GL_FLEXFIELDS_PKG.GET_SD_DESCRIPTION_SQL(BK.CHART_OF_ACCOUNTS_ID
, 2
, SD.DRILLDOWN_SEGNUM2
, SD.DRILLDOWN_SEGVAL2)
, SD.RELATIVE_PERIOD_POS
, SD.PERIOD_NAME
, SD.PERIOD_NUM
, SD.PERIOD_YEAR
, DECODE(SD.FIN_ITEM_ID
, 'REVENUE'
, -SD.PERIOD_TO_DATE
, 'CULIABL'
, -SD.PERIOD_TO_DATE
, SD.PERIOD_TO_DATE) PERIOD_TO_DATE
, DECODE(SD.FIN_ITEM_ID
, 'REVENUE'
, -SD.QUARTER_TO_DATE
, 'CULIABL'
, -SD.QUARTER_TO_DATE
, SD.QUARTER_TO_DATE) QUARTER_TO_DATE
, DECODE(SD.FIN_ITEM_ID
, 'REVENUE'
, -SD.YEAR_TO_DATE
, 'CULIABL'
, -SD.YEAR_TO_DATE
, SD.YEAR_TO_DATE) YEAR_TO_DATE
, DECODE(SD.FIN_ITEM_ID
, 'REVENUE'
, DECODE(SD.ACTUAL_FLAG
, 'A'
, -PERIOD_TO_DATE
, 0)
, 0) REVENUE_ACTUAL
, DECODE(SD.FIN_ITEM_ID
, 'REVENUE'
, DECODE(SD.ACTUAL_FLAG
, 'B'
, -PERIOD_TO_DATE
, 0)
, 0) REVENUE_PLAN
, DECODE(SD.FIN_ITEM_ID
, 'EXPENSE'
, DECODE(SD.ACTUAL_FLAG
, 'A'
, PERIOD_TO_DATE
, 0)
, 0) EXPENSE_ACTUAL
, DECODE(SD.FIN_ITEM_ID
, 'EXPENSE'
, DECODE(SD.ACTUAL_FLAG
, 'B'
, PERIOD_TO_DATE
, 0)
, 0) EXPENSE_PLAN
, DECODE(SD.FIN_ITEM_ID
, 'CUASSET'
, DECODE(SD.ACTUAL_FLAG
, 'A'
, YEAR_TO_DATE
, 0)
, 0) ASSET_ACTUAL
, DECODE(SD.FIN_ITEM_ID
, 'CUASSET'
, DECODE(SD.ACTUAL_FLAG
, 'B'
, YEAR_TO_DATE
, 0)
, 0) ASSET_PLAN
, DECODE(SD.FIN_ITEM_ID
, 'CULIABL'
, DECODE(SD.ACTUAL_FLAG
, 'A'
, -YEAR_TO_DATE
, 0)
, 0) LIABILITY_ACTUAL
, DECODE(SD.FIN_ITEM_ID
, 'CULIABL'
, DECODE(SD.ACTUAL_FLAG
, 'B'
, -YEAR_TO_DATE
, 0)
, 0) LIABILITY_PLAN
, DECODE(SD.FIN_ITEM_ID
, 'VARCOST'
, DECODE(SD.ACTUAL_FLAG
, 'A'
, PERIOD_TO_DATE
, 0)
, 0) VARCOST_ACTUAL
, DECODE(SD.FIN_ITEM_ID
, 'VARCOST'
, DECODE(SD.ACTUAL_FLAG
, 'B'
, PERIOD_TO_DATE
, 0)
, 0) VARCOST_PLAN
FROM GL_LOOKUPS LK
, GL_OASIS_SUMMARY_DATA SD
, GL_OASIS_FIN_ITEMS FI
, GL_SETS_OF_BOOKS BK
WHERE BK.SET_OF_BOOKS_ID = GL_SECURITY_PKG.LOGIN_SOB_ID
AND GL_SECURITY_PKG.VALIDATE_SEGVAL( SD.DRILLDOWN_SEGNUM1
, SD.DRILLDOWN_SEGNUM2
, SD.DRILLDOWN_SEGVAL1
, SD.DRILLDOWN_SEGVAL2) = 'TRUE'
AND FI.FIN_ITEM_ID = SD.FIN_ITEM_ID
AND BK.SET_OF_BOOKS_ID = SD.SET_OF_BOOKS_ID
AND LK.LOOKUP_TYPE = 'ACTUAL_PLAN'
AND LK.LOOKUP_CODE = SD.ACTUAL_FLAG WITH READ ONLY

Columns

Name
SET_OF_BOOKS_ID
SET_OF_BOOKS_NAME
FIN_ITEM_ID
FIN_ITEM_NAME
DRILLDOWN_SEGNUM1
DRILLDOWN_SEGNUM2
ACTUAL_FLAG
ACTUAL_FLAG_NAME
DRILLDOWN_SEGVAL1
DRILLDOWN_SEGVAL2
SEGVAL1_DESCRIPTION
SEGVAL2_DESCRIPTION
RELATIVE_PERIOD_POS
PERIOD_NAME
PERIOD_NUM
PERIOD_YEAR
PERIOD_TO_DATE
QUARTER_TO_DATE
YEAR_TO_DATE
REVENUE_ACTUAL
REVENUE_PLAN
EXPENSE_ACTUAL
EXPENSE_PLAN
ASSET_ACTUAL
ASSET_PLAN
LIABILITY_ACTUAL
LIABILITY_PLAN
VARCOST_ACTUAL
VARCOST_PLAN