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: FII_GL_SUMMARY_BY_LOB_V2

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

View Text

SELECT TIME_ID
, PERIOD_TYPE_ID
, FIN_ITEM
, MANAGER_ID
, LINE_OF_BUSINESS
, COST_CENTER_ORG_ID
, JE_SOURCE
, SET_OF_BOOKS_ID
, ACCT_CURRENCY_CODE
, PROFIT_CENTER_FLAG
, ACTUAL_B
, SEC_ACTUAL_G ACTUAL_G
, SEC_BUDGET_G BUDGET_G
, SEC_FORECAST_G FORECAST_G
FROM FII_GL_LOB_SUM_MV

Columns

Name
TIME_ID
PERIOD_TYPE_ID
FIN_ITEM
MANAGER_ID
LINE_OF_BUSINESS
COST_CENTER_ORG_ID
JE_SOURCE
SET_OF_BOOKS_ID
ACCT_CURRENCY_CODE
PROFIT_CENTER_FLAG
ACTUAL_B
ACTUAL_G
BUDGET_G
FORECAST_G