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 124: || ' FROM msc_system_items t2 '

120: l_entity_name := 'InstallBaseHistory';
121: v_sql_stmt := 01;
122: lv_sql_stmt := ' UPDATE ' || msd_schema_name || '.MSD_DEM_INS_BASE_HISTORY t1'
123: || ' SET t1.level1_sr_pk = ( SELECT t2.sr_inventory_item_id '
124: || ' FROM msc_system_items t2 '
125: || ' WHERE t2.sr_instance_id = :p_instance_id '
126: || ' AND t2.item_name = t1.level1 '
127: || ' AND rownum = 1) ';
128:

Line 138: || ' FROM msc_system_items t2 '

134: v_sql_stmt := 02;
135: lv_sql_stmt := ' UPDATE ' || msd_schema_name
136: || '.MSD_DEM_FLD_SER_USG_HISTORY t1'
137: || ' SET t1.level1_sr_pk = ( SELECT distinct(t2.sr_inventory_item_id) '
138: || ' FROM msc_system_items t2 '
139: || ' WHERE t2.sr_instance_id = :p_instance_id '
140: || ' AND t2.item_name = t1.level1 '
141: || ' AND rownum = 1) ' ;
142:

Line 161: || ' FROM msc_system_items t2 '

157: lv_sql_stmt := ' UPDATE '
158: || msd_schema_name
159: || '.MSD_DEM_DPT_REP_USG_HISTORY t1'
160: || ' SET t1.level1_sr_pk = ( SELECT distinct(t2.sr_inventory_item_id) '
161: || ' FROM msc_system_items t2 '
162: || ' WHERE t2.sr_instance_id = :p_instance_id '
163: || ' AND t2.item_name = t1.level1) ';
164:
165: lv_sql_stmt1 := ' UPDATE '

Line 183: || ' FROM msc_system_items t2 '

179: lv_sql_stmt := ' UPDATE '
180: || msd_schema_name
181: || '.MSD_DEM_SRP_RETURN_HISTORY t1'
182: || ' SET t1.level1_sr_pk = ( SELECT distinct(t2.sr_inventory_item_id) '
183: || ' FROM msc_system_items t2 '
184: || ' WHERE t2.sr_instance_id = :p_instance_id '
185: || ' AND t2.item_name = t1.level1 '
186: || ' AND rownum = 1) ';
187:

Line 206: || ' FROM msc_system_items t2 '

202:
203: lv_sql_stmt := 'UPDATE ' || msc_schema_name
204: || '.MSC_ITEM_FAILURE_RATES t1'
205: || ' SET t1.using_assembly_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.using_assembly_name),-55555) ';
209:
210: lv_sql_stmt1 := 'UPDATE ' || msc_schema_name

Line 213: || ' FROM msc_system_items t2 '

209:
210: lv_sql_stmt1 := 'UPDATE ' || msc_schema_name
211: || '.MSC_ITEM_FAILURE_RATES t1'
212: || ' SET t1.inventory_item_id = nvl((select distinct(t2.inventory_item_id) '
213: || ' FROM msc_system_items t2 '
214: || ' where t2.sr_instance_id = :p_instance_id '
215: || ' and t2.item_name = t1.item_name),-55555) ';
216:
217: lv_sql_stmt2 := ' UPDATE ' || msc_schema_name

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

249: v_sql_stmt := 06;
250: --lv_sql_stmt := ' UPDATE ' || msd_schema_name
251: --|| '.MSD_DEM_RETURN_HISTORY t1'
252: -- || ' SET t1.level1_sr_pk = ( SELECT distinct(t2.sr_inventory_item_id) '
253: --|| ' FROM msc_system_items t2 '
254: -- || ' WHERE t2.sr_instance_id = :p_instance_id '
255: -- || ' AND t2.item_name = t1.level1) ';
256:
257: END IF;

Line 343: msc_system_items msi

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

Line 366: FROM msc_system_items

362: AND organization_code LIKE mdse.organization_lvl_val
363: AND rownum = 1)
364: AND mdse.product_lvl_val IN
365: (SELECT item_name
366: FROM msc_system_items
367: WHERE sr_instance_id = p_instance_id
368: AND item_name LIKE mdse.product_lvl_val
369: AND rownum = 1)
370: ;