eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSC_SYSTEM_ITEMS

Line 117: || ' FROM msc_system_items t2 '

113: l_entity_name := 'InstallBaseHistory';
114: v_sql_stmt := 01;
115: lv_sql_stmt := ' UPDATE ' || msd_schema_name || '.MSD_DEM_INS_BASE_HISTORY t1'
116: || ' SET t1.level1_sr_pk = ( SELECT t2.sr_inventory_item_id '
117: || ' FROM msc_system_items t2 '
118: || ' WHERE t2.sr_instance_id = :p_instance_id '
119: || ' AND t2.item_name = t1.level1 '
120: || ' AND rownum = 1) ';
121:

Line 131: || ' FROM msc_system_items t2 '

127: v_sql_stmt := 02;
128: lv_sql_stmt := ' UPDATE ' || msd_schema_name
129: || '.MSD_DEM_FLD_SER_USG_HISTORY t1'
130: || ' SET t1.level1_sr_pk = ( SELECT distinct(t2.sr_inventory_item_id) '
131: || ' FROM msc_system_items t2 '
132: || ' WHERE t2.sr_instance_id = :p_instance_id '
133: || ' AND t2.item_name = t1.level1 '
134: || ' AND rownum = 1) ' ;
135:

Line 154: || ' FROM msc_system_items t2 '

150: lv_sql_stmt := ' UPDATE '
151: || msd_schema_name
152: || '.MSD_DEM_DPT_REP_USG_HISTORY t1'
153: || ' SET t1.level1_sr_pk = ( SELECT distinct(t2.sr_inventory_item_id) '
154: || ' FROM msc_system_items t2 '
155: || ' WHERE t2.sr_instance_id = :p_instance_id '
156: || ' AND t2.item_name = t1.level1) ';
157:
158: lv_sql_stmt1 := ' UPDATE '

Line 176: || ' FROM msc_system_items t2 '

172: lv_sql_stmt := ' UPDATE '
173: || msd_schema_name
174: || '.MSD_DEM_SRP_RETURN_HISTORY t1'
175: || ' SET t1.level1_sr_pk = ( SELECT distinct(t2.sr_inventory_item_id) '
176: || ' FROM msc_system_items t2 '
177: || ' WHERE t2.sr_instance_id = :p_instance_id '
178: || ' AND t2.item_name = t1.level1 '
179: || ' AND rownum = 1) ';
180:

Line 199: || ' FROM msc_system_items t2 '

195:
196: lv_sql_stmt := 'UPDATE ' || msc_schema_name
197: || '.MSC_ITEM_FAILURE_RATES t1'
198: || ' SET t1.using_assembly_id = nvl((select distinct(t2.inventory_item_id)'
199: || ' FROM msc_system_items t2 '
200: || ' where t2.sr_instance_id = :p_instance_id '
201: || ' and t2.item_name = t1.using_assembly_name),-55555) ';
202:
203: lv_sql_stmt1 := 'UPDATE ' || msc_schema_name

Line 206: || ' FROM msc_system_items t2 '

202:
203: lv_sql_stmt1 := 'UPDATE ' || msc_schema_name
204: || '.MSC_ITEM_FAILURE_RATES t1'
205: || ' SET t1.inventory_item_id = nvl((select distinct(t2.inventory_item_id) '
206: || ' FROM msc_system_items t2 '
207: || ' where t2.sr_instance_id = :p_instance_id '
208: || ' and t2.item_name = t1.item_name),-55555) ';
209:
210: lv_sql_stmt2 := ' UPDATE ' || msc_schema_name

Line 246: --|| ' FROM msc_system_items t2 '

242: v_sql_stmt := 06;
243: --lv_sql_stmt := ' UPDATE ' || msd_schema_name
244: --|| '.MSD_DEM_RETURN_HISTORY t1'
245: -- || ' SET t1.level1_sr_pk = ( SELECT distinct(t2.sr_inventory_item_id) '
246: --|| ' FROM msc_system_items t2 '
247: -- || ' WHERE t2.sr_instance_id = :p_instance_id '
248: -- || ' AND t2.item_name = t1.level1) ';
249:
250: END IF;

Line 336: msc_system_items msi

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
340: AND mdse.product_lvl_val = msi.item_name

Line 359: FROM msc_system_items

355: AND organization_code LIKE mdse.organization_lvl_val
356: AND rownum = 1)
357: AND mdse.product_lvl_val IN
358: (SELECT item_name
359: FROM msc_system_items
360: WHERE sr_instance_id = p_instance_id
361: AND item_name LIKE mdse.product_lvl_val
362: AND rownum = 1)
363: ;