VIEW: APPS.FII_GL_SNAP_F_S_V

Source

View Text - Preformatted

SELECT COST_CENTER_DIM_ID, COMPANY_DIM_ID, FIN_CATEGORY_ID, USER_DIM1_ID, USER_DIM2_ID, LEDGER_ID, ACTUAL_B_CUR_MTD, ACTUAL_B_CUR_QTD, ACTUAL_B_CUR_YTD, ACTUAL_B_PRIOR_MTD, ACTUAL_B_PRIOR_QTD, ACTUAL_B_PRIOR_YTD, ACTUAL_B_LAST_YEAR_MTD, ACTUAL_B_LAST_YEAR_QTD, ACTUAL_SG_CUR_MTD, ACTUAL_SG_CUR_QTD, ACTUAL_SG_CUR_YTD, ACTUAL_SG_PRIOR_MTD, ACTUAL_SG_PRIOR_QTD, ACTUAL_SG_PRIOR_YTD, ACTUAL_SG_LAST_YEAR_MTD, ACTUAL_SG_LAST_YEAR_QTD, BUDGET_SG_CUR_MTD, BUDGET_SG_CUR_QTD, BUDGET_SG_CUR_YTD, BUDGET_SG_PRIOR_MTD, BUDGET_SG_PRIOR_QTD, BUDGET_SG_PRIOR_YTD, BUDGET_SG_LAST_YEAR_MTD, BUDGET_SG_LAST_YEAR_QTD, FORECAST_SG_CUR_MTD, FORECAST_SG_CUR_QTD, FORECAST_SG_CUR_YTD, FORECAST_SG_PRIOR_MTD, FORECAST_SG_PRIOR_QTD, FORECAST_SG_PRIOR_YTD, FORECAST_SG_LAST_YEAR_MTD, FORECAST_SG_LAST_YEAR_QTD , posted_date from fii_gl_snap_f

View Text - HTML Formatted

SELECT COST_CENTER_DIM_ID
, COMPANY_DIM_ID
, FIN_CATEGORY_ID
, USER_DIM1_ID
, USER_DIM2_ID
, LEDGER_ID
, ACTUAL_B_CUR_MTD
, ACTUAL_B_CUR_QTD
, ACTUAL_B_CUR_YTD
, ACTUAL_B_PRIOR_MTD
, ACTUAL_B_PRIOR_QTD
, ACTUAL_B_PRIOR_YTD
, ACTUAL_B_LAST_YEAR_MTD
, ACTUAL_B_LAST_YEAR_QTD
, ACTUAL_SG_CUR_MTD
, ACTUAL_SG_CUR_QTD
, ACTUAL_SG_CUR_YTD
, ACTUAL_SG_PRIOR_MTD
, ACTUAL_SG_PRIOR_QTD
, ACTUAL_SG_PRIOR_YTD
, ACTUAL_SG_LAST_YEAR_MTD
, ACTUAL_SG_LAST_YEAR_QTD
, BUDGET_SG_CUR_MTD
, BUDGET_SG_CUR_QTD
, BUDGET_SG_CUR_YTD
, BUDGET_SG_PRIOR_MTD
, BUDGET_SG_PRIOR_QTD
, BUDGET_SG_PRIOR_YTD
, BUDGET_SG_LAST_YEAR_MTD
, BUDGET_SG_LAST_YEAR_QTD
, FORECAST_SG_CUR_MTD
, FORECAST_SG_CUR_QTD
, FORECAST_SG_CUR_YTD
, FORECAST_SG_PRIOR_MTD
, FORECAST_SG_PRIOR_QTD
, FORECAST_SG_PRIOR_YTD
, FORECAST_SG_LAST_YEAR_MTD
, FORECAST_SG_LAST_YEAR_QTD
, POSTED_DATE
FROM FII_GL_SNAP_F