VIEW: APPS.MSD_PREVIOUS_LIAB_CS_V

Source

View Text - Preformatted

SELECT mdse.demand_plan_id, mdsc.supply_plan_name, mdse.ORGANIZATION_LVL_PK, mdse.ORGANIZATION_LVL_ID, mdse.PRODUCT_LVL_PK, mdse.PRODUCT_LVL_ID, mdse.GEOGRAPHY_LVL_PK, mdse.GEOGRAPHY_LVL_ID, mdse.TIME_LVL_ID, mdse.TIME_LVL_VAL_TO, mdse.QUANTITY, mdse.AMOUNT, mdse.CREATION_DATE, mdse.CREATED_BY, mdse.LAST_UPDATE_DATE, mdse.LAST_UPDATED_BY, mdse.LAST_UPDATE_LOGIN, 1, 1, 'I', to_number(null), to_number(null) FROM MSD_DP_SCENARIO_ENTRIES MDSE, MSD_DP_SESSION MDS, MSD_DEMAND_PLANS MDP, MSD_DP_SCENARIOS MDSC, MSD_DP_PARAMETERS MDPR WHERE MDP.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID AND MDSC.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID AND MDPR.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID AND MDSE.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID AND MDSE.SCENARIO_ID = MDSC.SCENARIO_ID AND MDSC.ASSOCIATE_PARAMETER = MDPR.PARAMETER_ID AND MDPR.PARAMETER_TYPE='MSD_TOTAL_LIAB' AND nvl(MDSC.SC_TYPE,'ABCD') <> 'ARCHIVED' AND mdse.revision = (select max(mdsr.revision) from msd_dp_scenario_revisions mdsr where mdsr.demand_plan_id = mdp.demand_plan_id and mdsr.scenario_id = mdsc.scenario_id )

View Text - HTML Formatted

SELECT MDSE.DEMAND_PLAN_ID
, MDSC.SUPPLY_PLAN_NAME
, MDSE.ORGANIZATION_LVL_PK
, MDSE.ORGANIZATION_LVL_ID
, MDSE.PRODUCT_LVL_PK
, MDSE.PRODUCT_LVL_ID
, MDSE.GEOGRAPHY_LVL_PK
, MDSE.GEOGRAPHY_LVL_ID
, MDSE.TIME_LVL_ID
, MDSE.TIME_LVL_VAL_TO
, MDSE.QUANTITY
, MDSE.AMOUNT
, MDSE.CREATION_DATE
, MDSE.CREATED_BY
, MDSE.LAST_UPDATE_DATE
, MDSE.LAST_UPDATED_BY
, MDSE.LAST_UPDATE_LOGIN
, 1
, 1
, 'I'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MSD_DP_SCENARIO_ENTRIES MDSE
, MSD_DP_SESSION MDS
, MSD_DEMAND_PLANS MDP
, MSD_DP_SCENARIOS MDSC
, MSD_DP_PARAMETERS MDPR
WHERE MDP.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MDSC.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MDPR.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MDSE.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MDSE.SCENARIO_ID = MDSC.SCENARIO_ID
AND MDSC.ASSOCIATE_PARAMETER = MDPR.PARAMETER_ID
AND MDPR.PARAMETER_TYPE='MSD_TOTAL_LIAB'
AND NVL(MDSC.SC_TYPE
, 'ABCD') <> 'ARCHIVED'
AND MDSE.REVISION = (SELECT MAX(MDSR.REVISION)
FROM MSD_DP_SCENARIO_REVISIONS MDSR
WHERE MDSR.DEMAND_PLAN_ID = MDP.DEMAND_PLAN_ID
AND MDSR.SCENARIO_ID = MDSC.SCENARIO_ID )