VIEW: APPS.MSD_LB_PREV_LIAB_CS_V

Source

View Text - Preformatted

SELECT mdp.demand_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.DEMAND_CLASS_LVL_PK, mdse.dEMAND_CLASS_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_demand_plans mdp, msd_dp_scenarios mds WHERE mds.demand_plan_id = mdp.demand_plan_id and mdp.plan_type = 'LIABILITY' and mds.scenario_designator = 'TOTAL_LIABILITY' and mdse.demand_plan_id = mds.demand_plan_id and mdse.scenario_id = mds.scenario_id 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 = mds.scenario_id and mdsr.creation_date > mdp.creation_date)

View Text - HTML Formatted

SELECT MDP.DEMAND_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.DEMAND_CLASS_LVL_PK
, MDSE.DEMAND_CLASS_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_DEMAND_PLANS MDP
, MSD_DP_SCENARIOS MDS
WHERE MDS.DEMAND_PLAN_ID = MDP.DEMAND_PLAN_ID
AND MDP.PLAN_TYPE = 'LIABILITY'
AND MDS.SCENARIO_DESIGNATOR = 'TOTAL_LIABILITY'
AND MDSE.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MDSE.SCENARIO_ID = MDS.SCENARIO_ID
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 = MDS.SCENARIO_ID
AND MDSR.CREATION_DATE > MDP.CREATION_DATE)