Product: | FII - Financial Intelligence |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FII_GL_SNAP_SUM_F_P_V |
SELECT COST_CENTER_DIM_ID
, PARENT_COST_CENTER_DIM_ID
, COMPANY_DIM_ID
, PARENT_COMPANY_DIM_ID
, FIN_CATEGORY_ID
, PARENT_FIN_CATEGORY_ID
, USER_DIM1_ID
, PARENT_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_SUM_F