APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSC_ITEM_FAILURE_RATES

Line 60: SELECT * from MSC_ITEM_FAILURE_RATES

56: WHERE demand_plan_id = 5555555
57: AND scenario_id = l_scenario_id;
58:
59: CURSOR get_err_records IS
60: SELECT * from MSC_ITEM_FAILURE_RATES
61: where process_flag = 'E';
62:
63: msd_schema_name VARCHAR2(100);
64: msc_schema_name VARCHAR2(100);

Line 204: || '.MSC_ITEM_FAILURE_RATES t1'

200: l_entity_name := 'Failure Rates';
201: v_sql_stmt := 05;
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) ';

Line 211: || '.MSC_ITEM_FAILURE_RATES t1'

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
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) ';

Line 218: || '.MSC_ITEM_FAILURE_RATES '

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
218: || '.MSC_ITEM_FAILURE_RATES '
219: || ' SET FAILURE_RATE = 1'
220: || ' where failure_rate > 1'
221: || ' and process_flag = ''N'' ';
222:

Line 224: || '.MSC_ITEM_FAILURE_RATES '

220: || ' where failure_rate > 1'
221: || ' and process_flag = ''N'' ';
222:
223: lv_sql_stmt3 := ' UPDATE ' || msc_schema_name
224: || '.MSC_ITEM_FAILURE_RATES '
225: || ' SET FAILURE_RATE = 0'
226: || ' where failure_rate < 0'
227: || ' and process_flag = ''N'' ';
228:

Line 230: || '.MSC_ITEM_FAILURE_RATES '

226: || ' where failure_rate < 0'
227: || ' and process_flag = ''N'' ';
228:
229: lv_sql_stmt4 := ' UPDATE ' || msc_schema_name
230: || '.MSC_ITEM_FAILURE_RATES '
231: || ' SET PROCESS_FLAG = ''P'''
232: || ' where PROCESS_FLAG = ''N''';
233:
234: lv_sql_stmt5 := ' UPDATE ' || msc_schema_name

Line 235: || '.MSC_ITEM_FAILURE_RATES '

231: || ' SET PROCESS_FLAG = ''P'''
232: || ' where PROCESS_FLAG = ''N''';
233:
234: lv_sql_stmt5 := ' UPDATE ' || msc_schema_name
235: || '.MSC_ITEM_FAILURE_RATES '
236: || ' SET PROCESS_FLAG = ''E'''
237: || ' where PROCESS_FLAG = ''N'''
238: || ' and (USING_ASSEMBLY_ID = -55555 or INVENTORY_ITEM_ID = -55555) ';
239:

Line 241: || '.MSC_ITEM_FAILURE_RATES '

237: || ' where PROCESS_FLAG = ''N'''
238: || ' and (USING_ASSEMBLY_ID = -55555 or INVENTORY_ITEM_ID = -55555) ';
239:
240: lv_sql_stmt6 := 'DELETE FROM ' || msc_schema_name
241: || '.MSC_ITEM_FAILURE_RATES '
242: || 'WHERE PROCESS_FLAG = ''E''';
243:
244: END IF;
245: