APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSC_TRADING_PARTNERS

Line 162: || ' FROM msc_trading_partners t2 '

158: lv_sql_stmt1 := ' UPDATE '
159: || msd_schema_name
160: || '.MSD_DEM_DPT_REP_USG_HISTORY t1'
161: || ' SET t1.level2_sr_pk = ( SELECT t2.sr_tp_id '
162: || ' FROM msc_trading_partners t2 '
163: || ' where t2.sr_instance_id = :p_instance_id '
164: || ' AND t2.organization_code = t1.level2) ';
165:
166: END IF;

Line 335: msc_trading_partners mtp,

331: mdse.total_quantity,
332: mdse.creation_date,
333: mdse.created_by
334: FROM msd_dp_scenario_entries mdse,
335: msc_trading_partners mtp,
336: msc_system_items msi
337: WHERE mdse.demand_plan_id = 5555555
338: AND mdse.scenario_id = l_scenario_id
339: AND mdse.organization_lvl_val = mtp.organization_code

Line 352: FROM msc_trading_partners

348: DELETE FROM msd_dp_scenario_entries mdse
349: WHERE mdse.scenario_id = l_scenario_id
350: AND mdse.organization_lvl_val IN
351: (SELECT organization_code
352: FROM msc_trading_partners
353: WHERE sr_instance_id = p_instance_id
354: AND partner_type = 3
355: AND organization_code LIKE mdse.organization_lvl_val
356: AND rownum = 1)