APPS.MSC_ATO_FORECAST SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

       SELECT common_routing_sequence_id into l_common_rout_seq_id
       from msc_routings mr
       where mr.plan_id = -1
       and   mr.sr_instance_id = p_sr_instance_id
       and   mr.organization_id = p_org_id
       and   mr.assembly_item_id = p_inventory_item_id;

Line: 42

       select bom_item_type into l_parent_item_type
       from msc_system_items msi,
            msc_routings mr
       where mr.routing_sequence_id = l_common_rout_seq_id
       and   mr.sr_instance_id = p_sr_instance_id
       and   mr.plan_id = -1
       and   mr.organization_id = p_org_id
       and   msi.inventory_item_id = mr.assembly_item_id
       and   msi.sr_instance_id = mr.sr_instance_id
       and   msi.organization_id = mr.organization_id
       and   msi.plan_id = mr.plan_id;