DBA Data[Home] [Help]

APPS.MSD_EOL_PLAN dependencies on MSD_DP_DOC_DIM_SELECTIONS

Line 179: from msd_dp_doc_dim_selections

175: and stream_type='ARCHIVED';
176:
177: cursor c2 is
178: select distinct selection_component,selection_value,supply_plan_name
179: from msd_dp_doc_dim_selections
180: where demand_plan_id=p_demand_plan_id
181: and dimension_code='MEAS'
182: and document_id=(select document_id from msd_dp_seeded_documents where document_name='MSD_SD_EOL_LWF' and demand_plan_id=p_demand_plan_id);
183:

Line 539: INSERT INTO msd_dp_doc_dim_selections

535: and mdp.demand_plan_id=p_demand_plan_id;
536:
537:
538:
539: INSERT INTO msd_dp_doc_dim_selections
540: (DEMAND_PLAN_ID
541: ,DOCUMENT_ID
542: ,DIMENSION_CODE
543: ,ENABLED_FLAG

Line 585: msd_dp_doc_dim_selections mdds

581: ,SYSDATE
582: FROM
583: msd_dp_seeded_documents mdsd,
584: msd_dp_seeded_documents mdsd1,
585: msd_dp_doc_dim_selections mdds
586: WHERE
587: mdsd.document_name='MSD_SD_EOL_LWF'
588: and mdsd.demand_plan_id= (select template_id from msd_demand_plans where demand_plan_id=p_demand_plan_id)
589: and mdsd1.document_name=mdsd.document_name