[Home] [Help]
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;
136: reciprocal_flag,
137: msc_sda_utils.getRepairItem(plan_id, lower_item_id, highest_item_id) repair_item_id,
138: prime_item_id,
139: effective_date, disable_date
140: from msc_item_substitutes
141: where plan_id = p_plan
142: and relationship_type = c_mis_supersession_type
143: and highest_item_id = p_item
144: and inferred_flag = 2
271:
272: cursor c_prime_ss_cur is
273: select decode(p_item_id, lower_item_id, prime_item_id, higher_item_id),
274: highest_item_id
275: from msc_item_substitutes
276: where plan_id = p_plan_id
277: and relationship_type = c_mis_supersession_type
278: and inferred_flag = 2
279: and forward_rule = 1
566: msc_get_name.item_name(p_item_id,null, null, null) top_item_name,
567: decode(p_item_id, prime_item_id, lower_item_id, higher_item_id) item_id,
568: msc_get_name.item_name(decode(p_item_id, prime_item_id, lower_item_id, higher_item_id),null, null, null) item_name,
569: 1 sort_column
570: from msc_item_substitutes
571: where plan_id = p_plan_id
572: and (prime_item_id = p_item_id or (higher_item_id = highest_item_id and higher_item_id = p_item_id))
573: and relationship_type = c_mis_supersession_type
574: and p_item_view_type = c_prime_view
590: msc_get_name.item_name(highest_item_id,null, null, null) top_item_name,
591: lower_item_id item_id,
592: msc_get_name.item_name(lower_item_id,null, null, null) item_name,
593: 1 sort_column
594: from msc_item_substitutes
595: where plan_id = p_plan_id
596: and relationship_type = c_mis_supersession_type
597: and p_item_view_type = c_supersession_view
598: and highest_item_id = p_item_id