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 197: || '.MSC_ITEM_FAILURE_RATES t1'

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

Line 204: || '.MSC_ITEM_FAILURE_RATES t1'

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

Line 211: || '.MSC_ITEM_FAILURE_RATES '

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
211: || '.MSC_ITEM_FAILURE_RATES '
212: || ' SET FAILURE_RATE = 1'
213: || ' where failure_rate > 1'
214: || ' and process_flag = ''N'' ';
215:

Line 217: || '.MSC_ITEM_FAILURE_RATES '

213: || ' where failure_rate > 1'
214: || ' and process_flag = ''N'' ';
215:
216: lv_sql_stmt3 := ' UPDATE ' || msc_schema_name
217: || '.MSC_ITEM_FAILURE_RATES '
218: || ' SET FAILURE_RATE = 0'
219: || ' where failure_rate < 0'
220: || ' and process_flag = ''N'' ';
221:

Line 223: || '.MSC_ITEM_FAILURE_RATES '

219: || ' where failure_rate < 0'
220: || ' and process_flag = ''N'' ';
221:
222: lv_sql_stmt4 := ' UPDATE ' || msc_schema_name
223: || '.MSC_ITEM_FAILURE_RATES '
224: || ' SET PROCESS_FLAG = ''P'''
225: || ' where PROCESS_FLAG = ''N''';
226:
227: lv_sql_stmt5 := ' UPDATE ' || msc_schema_name

Line 228: || '.MSC_ITEM_FAILURE_RATES '

224: || ' SET PROCESS_FLAG = ''P'''
225: || ' where PROCESS_FLAG = ''N''';
226:
227: lv_sql_stmt5 := ' UPDATE ' || msc_schema_name
228: || '.MSC_ITEM_FAILURE_RATES '
229: || ' SET PROCESS_FLAG = ''E'''
230: || ' where PROCESS_FLAG = ''N'''
231: || ' and (USING_ASSEMBLY_ID = -55555 or INVENTORY_ITEM_ID = -55555) ';
232:

Line 234: || '.MSC_ITEM_FAILURE_RATES '

230: || ' where PROCESS_FLAG = ''N'''
231: || ' and (USING_ASSEMBLY_ID = -55555 or INVENTORY_ITEM_ID = -55555) ';
232:
233: lv_sql_stmt6 := 'DELETE FROM ' || msc_schema_name
234: || '.MSC_ITEM_FAILURE_RATES '
235: || 'WHERE PROCESS_FLAG = ''E''';
236:
237: END IF;
238: