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.MSC_SDA_UTILS dependencies on MSC_ITEM_SUBSTITUTES

Line 112: from msc_item_substitutes

108: function getRepairItem(p_plan_id number, p_lower_item_id number, p_highest_item_id number) return number is
109:
110: cursor c_repair_item_cur is
111: select higher_item_id
112: from msc_item_substitutes
113: where plan_id = p_plan_id
114: and relationship_type = c_mis_repair_to_type
115: and lower_item_id = p_lower_item_id;
116: --and highest_item_id = p_highest_item_id;

Line 152: from msc_item_substitutes b, msc_plans mp

148:
149: cursor c_ods_data_cur(l_number1 number, l_number2 number) is
150: select b.effective_date,
151: b.disable_date
152: from msc_item_substitutes b, msc_plans mp
153: where b.plan_id = -1
154: and b.relationship_type = 8
155: and b.lower_item_id = l_number1
156: and b.higher_item_id = l_number2

Line 177: from msc_item_substitutes b, msc_plans mp

173: msc_sda_utils.getRepairItem(b.plan_id, b.lower_item_id, b.highest_item_id) repair_item_id,
174: b.prime_item_id,
175: b.effective_date,
176: b.disable_date
177: from msc_item_substitutes b, msc_plans mp
178: where b.plan_id = p_plan
179: and b.relationship_type = c_mis_supersession_type
180: and b.highest_item_id = p_item
181: and b.inferred_flag = 2

Line 202: from msc_item_substitutes b, msc_plans mp

198: msc_sda_utils.getRepairItem(b.plan_id, b.lower_item_id, b.highest_item_id) repair_item_id,
199: b.prime_item_id,
200: b.effective_date,
201: b.disable_date
202: from msc_item_substitutes b, msc_plans mp
203: where b.plan_id = p_plan
204: and b.relationship_type = c_mis_supersession_type
205: and b.highest_item_id = p_item
206: and b.inferred_flag = 2

Line 245: from msc_item_substitutes mis

241:
242: function is_item_in_chain(p_plan number, p_item_id number) return number is
243: cursor c_check_cur is
244: select count(*)
245: from msc_item_substitutes mis
246: where plan_id = p_plan
247: and mis.relationship_type = c_mis_supersession_type
248: and mis.inferred_flag = 2
249: and mis.forward_rule = 1

Line 291: msc_item_substitutes mis,

287: cursor c_highest_cur is
288: select distinct mis.highest_item_id
289: from msc_system_items msi,
290: msc_plans mp,
291: msc_item_substitutes mis,
292: msc_system_items msi2
293: where mp.plan_id = p_plan
294: and msi.plan_id = mp.plan_id
295: and msi.sr_instance_id = mp.sr_instance_id

Line 325: from msc_item_substitutes mis,

321: order by 1;
322:
323: cursor c_highest_item_cur (ll_query_id number) is
324: select distinct mis.highest_item_id
325: from msc_item_substitutes mis,
326: msc_form_query mfq
327: where mis.plan_id = p_plan
328: and mis.relationship_type = c_mis_supersession_type
329: and mis.inferred_flag = 2

Line 463: (select min(a.effective_date) from msc_item_substitutes a

459: b.lower_item_id, b.higher_item_id, b.highest_item_id, level,
460: b.reciprocal_flag,
461: msc_sda_utils.getRepairItem(plan_id, b.lower_item_id, b.highest_item_id) repair_item_id,
462: b.prime_item_id,
463: (select min(a.effective_date) from msc_item_substitutes a
464: where a.plan_id=p_plan
465: and a.lower_item_id = b.lower_item_id
466: and a.HIGHER_ITEM_ID=b.higher_item_id
467: and a.relationship_type = c_mis_supersession_type

Line 471: from msc_item_substitutes b

467: and a.relationship_type = c_mis_supersession_type
468: and a.inferred_flag = 2
469: and a.forward_rule = 1) as effective_date,
470: disable_date
471: from msc_item_substitutes b
472: where b.plan_id = p_plan
473: and b.relationship_type = c_mis_supersession_type
474: and b.highest_item_id = p_item
475: and b.inferred_flag = 2

Line 611: from msc_item_substitutes b, msc_plans mp

607: cursor c_prime_ss_cur is
608: select b.prime_item_id,
609: b.highest_item_id,
610: b.effective_date
611: from msc_item_substitutes b, msc_plans mp
612: where b.plan_id = p_plan_id
613: and b.relationship_type = c_mis_supersession_type
614: and b.inferred_flag = 2
615: and b.forward_rule = 1

Line 629: from msc_item_substitutes b, msc_plans mp

625: cursor c_prime_ss_cur1 is
626: select b.highest_item_id prime_item_id,
627: b.highest_item_id,
628: b.effective_date
629: from msc_item_substitutes b, msc_plans mp
630: where b.plan_id = p_plan_id
631: and b.relationship_type = c_mis_supersession_type
632: and b.inferred_flag = 2
633: and b.forward_rule = 1

Line 938: from msc_item_substitutes b, msc_plans mp

934: msc_get_name.item_name(p_item_id,null, null, null) top_item_name,
935: decode(p_item_id, b.prime_item_id, b.lower_item_id, b.higher_item_id) item_id,
936: msc_get_name.item_name(decode(p_item_id, b.prime_item_id, b.lower_item_id, b.higher_item_id),null, null, null) item_name,
937: 1 sort_column
938: from msc_item_substitutes b, msc_plans mp
939: where b.plan_id = p_plan_id
940: and (b.prime_item_id = p_item_id
941: or (higher_item_id = highest_item_id and higher_item_id = p_item_id)
942: )

Line 968: from msc_item_substitutes b, msc_plans mp

964: msc_get_name.item_name(b.highest_item_id,null, null, null) top_item_name,
965: b.lower_item_id item_id,
966: msc_get_name.item_name(b.lower_item_id,null, null, null) item_name,
967: 1 sort_column
968: from msc_item_substitutes b, msc_plans mp
969: where b.plan_id = p_plan_id
970: and b.relationship_type = c_mis_supersession_type
971: and p_item_view_type = c_supersession_view
972: and b.highest_item_id = p_item_id

Line 2053: from msc_item_substitutes b

2049: );
2050:
2051: cursor c_chain_cur (l_plan_id number) is
2052: select count(*)
2053: from msc_item_substitutes b
2054: where b.plan_id = l_plan_id
2055: and b.inferred_flag=2
2056: and b.forward_rule=1
2057: and ( ( p_pk_value1 in (b.lower_item_id, b.higher_item_id)