APPS.MSC_SDA_UTILS dependencies on MSC_PLANS

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 290: msc_plans mp,

286:
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

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