APPS.MSC_ATO_FORECAST dependencies on MSC_ROUTINGS

Line 29: from msc_routings mr

25: END IF;
26:
27: /* Get the common_routing_sequence_id for given option class */
28: SELECT common_routing_sequence_id into l_common_rout_seq_id
29: from msc_routings mr
30: where mr.plan_id = -1
31: and mr.sr_instance_id = p_sr_instance_id
32: and mr.organization_id = p_org_id
33: and mr.assembly_item_id = p_inventory_item_id;

Line 44: msc_routings mr

40: /* If common routing exists then return true only if the assembly item of this common
41: routing is an ATO model */
42: select bom_item_type into l_parent_item_type
43: from msc_system_items msi,
44: msc_routings mr
45: where mr.routing_sequence_id = l_common_rout_seq_id
46: and mr.sr_instance_id = p_sr_instance_id
47: and mr.plan_id = -1
48: and mr.organization_id = p_org_id