APPS.MSC_GET_NAME dependencies on MSC_OPERATION_NETWORKS

Line 4165: from msc_operation_networks

4161: select dependency_type,
4162: minimum_transfer_qty,
4163: minimum_time_offset,
4164: maximum_time_offset
4165: from msc_operation_networks
4166: where plan_id = p_plan_id and
4167: sr_instance_id = p_sr_instance_id and
4168: routing_sequence_id = p_routing_seq_id and
4169: from_op_seq_id = p_operation_seq_id and

Line 4204: --If the details are not available in msc_operation_networks then

4200: open cur_mtq_details_mon ;
4201: fetch cur_mtq_details_mon into rec_mtq_details_mon;
4202: if cur_mtq_details_mon%notfound then
4203: close cur_mtq_details_mon;
4204: --If the details are not available in msc_operation_networks then
4205: --get it from msc_routing_operations.
4206: open cur_mtq_details_mro;
4207: fetch cur_mtq_details_mro into rec_mtq_details_mro;
4208: if cur_mtq_details_mro%notfound then

Line 4374: from msc_operation_networks

4370: select dependency_type,
4371: minimum_transfer_qty,
4372: minimum_time_offset,
4373: maximum_time_offset
4374: from msc_operation_networks
4375: where plan_id = p_plan_id and
4376: sr_instance_id = p_sr_instance_id and
4377: routing_sequence_id = p_routing_seq_id and
4378: from_op_seq_id = p_operation_seq_id and

Line 4443: from msc_operation_networks

4439: select distinct dependency_type,
4440: minimum_transfer_qty,
4441: minimum_time_offset,
4442: maximum_time_offset
4443: from msc_operation_networks
4444: where plan_id = p_plan_id
4445: and sr_instance_id = p_inst_id
4446: and routing_sequence_id = p_routing_seq_id
4447: and transition_type = 1