APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSC_TRADING_PARTNERS

Line 169: || ' FROM msc_trading_partners t2 '

165: lv_sql_stmt1 := ' UPDATE '
166: || msd_schema_name
167: || '.MSD_DEM_DPT_REP_USG_HISTORY t1'
168: || ' SET t1.level2_sr_pk = ( SELECT t2.sr_tp_id '
169: || ' FROM msc_trading_partners t2 '
170: || ' where t2.sr_instance_id = :p_instance_id '
171: || ' AND t2.organization_code = t1.level2) ';
172:
173: END IF;

Line 342: msc_trading_partners mtp,

338: mdse.total_quantity,
339: mdse.creation_date,
340: mdse.created_by
341: FROM msd_dp_scenario_entries mdse,
342: msc_trading_partners mtp,
343: msc_system_items msi
344: WHERE mdse.demand_plan_id = 5555555
345: AND mdse.scenario_id = l_scenario_id
346: AND mdse.organization_lvl_val = mtp.organization_code

Line 359: FROM msc_trading_partners

355: DELETE FROM msd_dp_scenario_entries mdse
356: WHERE mdse.scenario_id = l_scenario_id
357: AND mdse.organization_lvl_val IN
358: (SELECT organization_code
359: FROM msc_trading_partners
360: WHERE sr_instance_id = p_instance_id
361: AND partner_type = 3
362: AND organization_code LIKE mdse.organization_lvl_val
363: AND rownum = 1)