VIEW: APPS.MSD_PREVIOUS_LIAB_DS_V

Source

View Text - Preformatted

SELECT mds.demand_plan_id, 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, MSD_LEVEL_VALUES_DS PRD, MSD_LEVEL_VALUES_DS ORG, MSD_LEVEL_VALUES_DS GEO 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 ) AND MDSE.PRODUCT_LVL_PK = PRD.LEVEL_PK AND PRD.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID AND MDSE.ORGANIZATION_LVL_PK = ORG.LEVEL_PK AND ORG.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID AND MDSE.GEOGRAPHY_LVL_PK = GEO.LEVEL_PK AND GEO.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID

View Text - HTML Formatted

SELECT MDS.DEMAND_PLAN_ID
, 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
, MSD_LEVEL_VALUES_DS PRD
, MSD_LEVEL_VALUES_DS ORG
, MSD_LEVEL_VALUES_DS GEO
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 )
AND MDSE.PRODUCT_LVL_PK = PRD.LEVEL_PK
AND PRD.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MDSE.ORGANIZATION_LVL_PK = ORG.LEVEL_PK
AND ORG.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MDSE.GEOGRAPHY_LVL_PK = GEO.LEVEL_PK
AND GEO.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID