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.

Skip to content FND Design Data

[Home] [Help]

View: FII_GL_TREND_SUM_MV_P_V

Product:	FII - Financial Intelligence (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TIME_ID
, PERIOD_TYPE_ID
, BUDGET_VERSION_DATE
, PARENT_COMPANY_DIM_ID
, COMPANY_DIM_ID
, PARENT_COST_CENTER_DIM_ID
, COST_CENTER_DIM_ID
, PARENT_FIN_CATEGORY_DIM_ID
, FIN_CATEGORY_DIM_ID
, TOP_NODE_FIN_CAT_TYPE
, ACTUAL_B
, PRIM_ACTUAL_G
, PRIM_BUDGET_G
, PRIM_FORECAST_G
, COMMITTED_AMOUNT_PRIM
, OBLIGATED_AMOUNT_PRIM
, OTHER_AMOUNT_PRIM
, BASELINE_AMOUNT_PRIM
FROM FII_GL_TREND_SUM_MV

Columns

Name
TIME_ID
PERIOD_TYPE_ID
BUDGET_VERSION_DATE
PARENT_COMPANY_ID
COMPANY_ID
PARENT_COST_CENTER_ID
COST_CENTER_ID
PARENT_FIN_CATEGORY_ID
FIN_CATEGORY_ID
TOP_NODE_FIN_CAT_TYPE
ACTUAL_B
ACTUAL_G
BUDGET_G
FORECAST_G
COMMITMENTS_G
OBLIGATIONS_G
OTHERS_G
BASELINE_BUDGET_G