VIEW: APPS.FII_GL_SNAP_F_P_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_PG_CUR_MTD, ACTUAL_PG_CUR_QTD, ACTUAL_PG_CUR_YTD, ACTUAL_PG_PRIOR_MTD, ACTUAL_PG_PRIOR_QTD, ACTUAL_PG_PRIOR_YTD, ACTUAL_PG_LAST_YEAR_MTD, ACTUAL_PG_LAST_YEAR_QTD, BUDGET_PG_CUR_MTD, BUDGET_PG_CUR_QTD, BUDGET_PG_CUR_YTD, BUDGET_PG_PRIOR_MTD, BUDGET_PG_PRIOR_QTD, BUDGET_PG_PRIOR_YTD, BUDGET_PG_LAST_YEAR_MTD, BUDGET_PG_LAST_YEAR_QTD, FORECAST_PG_CUR_MTD, FORECAST_PG_CUR_QTD, FORECAST_PG_CUR_YTD, FORECAST_PG_PRIOR_MTD, FORECAST_PG_PRIOR_QTD, FORECAST_PG_PRIOR_YTD, FORECAST_PG_LAST_YEAR_MTD, FORECAST_PG_LAST_YEAR_QTD , COMMITTED_AMT_PG_CUR_MTD , COMMITTED_AMT_PG_CUR_QTD , COMMITTED_AMT_PG_CUR_YTD , COMMITTED_AMT_PG_PRIOR_MTD , COMMITTED_AMT_PG_PRIOR_QTD , COMMITTED_AMT_PG_PRIOR_YTD , COMMITTED_AMT_PG_LAST_YEAR_MTD , COMMITTED_AMT_PG_LAST_YEAR_QTD , OBLIGATED_AMT_PG_CUR_MTD , OBLIGATED_AMT_PG_CUR_QTD , OBLIGATED_AMT_PG_CUR_YTD , OBLIGATED_AMT_PG_PRIOR_MTD , OBLIGATED_AMT_PG_PRIOR_QTD , OBLIGATED_AMT_PG_PRIOR_YTD , OBLIGATED_AMT_PG_LAST_YEAR_MTD , OBLIGATED_AMT_PG_LAST_YEAR_QTD , OTHER_AMT_PG_CUR_MTD , OTHER_AMT_PG_CUR_QTD , OTHER_AMT_PG_CUR_YTD , OTHER_AMT_PG_PRIOR_MTD , OTHER_AMT_PG_PRIOR_QTD , OTHER_AMT_PG_PRIOR_YTD , OTHER_AMT_PG_LAST_YEAR_MTD , OTHER_AMT_PG_LAST_YEAR_QTD , BASELINE_AMT_PG_CUR_MTD , BASELINE_AMT_PG_CUR_QTD , BASELINE_AMT_PG_CUR_YTD , BASELINE_AMT_PG_PRIOR_MTD , BASELINE_AMT_PG_PRIOR_QTD , BASELINE_AMT_PG_PRIOR_YTD , BASELINE_AMT_PG_LAST_YEAR_MTD , BASELINE_AMT_PG_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_PG_CUR_MTD
, ACTUAL_PG_CUR_QTD
, ACTUAL_PG_CUR_YTD
, ACTUAL_PG_PRIOR_MTD
, ACTUAL_PG_PRIOR_QTD
, ACTUAL_PG_PRIOR_YTD
, ACTUAL_PG_LAST_YEAR_MTD
, ACTUAL_PG_LAST_YEAR_QTD
, BUDGET_PG_CUR_MTD
, BUDGET_PG_CUR_QTD
, BUDGET_PG_CUR_YTD
, BUDGET_PG_PRIOR_MTD
, BUDGET_PG_PRIOR_QTD
, BUDGET_PG_PRIOR_YTD
, BUDGET_PG_LAST_YEAR_MTD
, BUDGET_PG_LAST_YEAR_QTD
, FORECAST_PG_CUR_MTD
, FORECAST_PG_CUR_QTD
, FORECAST_PG_CUR_YTD
, FORECAST_PG_PRIOR_MTD
, FORECAST_PG_PRIOR_QTD
, FORECAST_PG_PRIOR_YTD
, FORECAST_PG_LAST_YEAR_MTD
, FORECAST_PG_LAST_YEAR_QTD
, COMMITTED_AMT_PG_CUR_MTD
, COMMITTED_AMT_PG_CUR_QTD
, COMMITTED_AMT_PG_CUR_YTD
, COMMITTED_AMT_PG_PRIOR_MTD
, COMMITTED_AMT_PG_PRIOR_QTD
, COMMITTED_AMT_PG_PRIOR_YTD
, COMMITTED_AMT_PG_LAST_YEAR_MTD
, COMMITTED_AMT_PG_LAST_YEAR_QTD
, OBLIGATED_AMT_PG_CUR_MTD
, OBLIGATED_AMT_PG_CUR_QTD
, OBLIGATED_AMT_PG_CUR_YTD
, OBLIGATED_AMT_PG_PRIOR_MTD
, OBLIGATED_AMT_PG_PRIOR_QTD
, OBLIGATED_AMT_PG_PRIOR_YTD
, OBLIGATED_AMT_PG_LAST_YEAR_MTD
, OBLIGATED_AMT_PG_LAST_YEAR_QTD
, OTHER_AMT_PG_CUR_MTD
, OTHER_AMT_PG_CUR_QTD
, OTHER_AMT_PG_CUR_YTD
, OTHER_AMT_PG_PRIOR_MTD
, OTHER_AMT_PG_PRIOR_QTD
, OTHER_AMT_PG_PRIOR_YTD
, OTHER_AMT_PG_LAST_YEAR_MTD
, OTHER_AMT_PG_LAST_YEAR_QTD
, BASELINE_AMT_PG_CUR_MTD
, BASELINE_AMT_PG_CUR_QTD
, BASELINE_AMT_PG_CUR_YTD
, BASELINE_AMT_PG_PRIOR_MTD
, BASELINE_AMT_PG_PRIOR_QTD
, BASELINE_AMT_PG_PRIOR_YTD
, BASELINE_AMT_PG_LAST_YEAR_MTD
, BASELINE_AMT_PG_LAST_YEAR_QTD
, POSTED_DATE
FROM FII_GL_SNAP_F