DBA Data[Home] [Help]

VIEW: APPS.FII_GL_TREND_SUM_MV_P_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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