APPS.MSC_ATP_SUBST dependencies on MSC_ITEM_SUBSTITUTES

Line 4957: FROM msc_item_substitutes mis,

4953: p_item_table.family_item_name,
4954: p_item_table.atf_date,
4955: p_item_table.atf_date_quantity
4956: -- time_phased_atp changes end
4957: FROM msc_item_substitutes mis,
4958: msc_system_items msi1,
4959: msc_system_items msi2
4960: WHERE mis.plan_id = p_plan_id
4961: AND mis.sr_instance_id = p_instance_id

Line 4991: FROM msc_item_substitutes mis

4987: END IF;
4988: ELSE
4989: SELECT count(*)
4990: INTO l_count
4991: FROM msc_item_substitutes mis
4992: WHERE mis.plan_id = p_plan_id
4993: AND mis.sr_instance_id = p_instance_id
4994: ---bug 2341179 : inferred_flag is used for UI purpose only
4995: --AND mis.inferred_flag = 2

Line 5046: FROM msc_item_substitutes mis,

5042: p_item_table.family_item_name,
5043: p_item_table.atf_date,
5044: p_item_table.atf_date_quantity
5045: -- time_phased_atp changes end
5046: FROM msc_item_substitutes mis,
5047: msc_system_items msi1,
5048: msc_system_items msi2
5049: WHERE mis.plan_id = p_plan_id
5050: AND mis.sr_instance_id = p_instance_id

Line 5148: FROM msc_item_substitutes mis,

5144: ,p_item_table.family_dest_id
5145: ,p_item_table.family_item_name
5146: ,p_item_table.atf_date
5147: ,p_item_table.atf_date_quantity
5148: FROM msc_item_substitutes mis,
5149: msc_system_items msi1,
5150: msc_system_items msi2
5151: WHERE mis.plan_id = p_plan_id
5152: AND mis.sr_instance_id = p_instance_id