eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_GET_NAME dependencies on MSC_OPERATION_NETWORKS

Line 3708: from msc_operation_networks

3704: select dependency_type,
3705: minimum_transfer_qty,
3706: minimum_time_offset,
3707: maximum_time_offset
3708: from msc_operation_networks
3709: where plan_id = p_plan_id and
3710: sr_instance_id = p_sr_instance_id and
3711: routing_sequence_id = p_routing_seq_id and
3712: from_op_seq_id = p_operation_seq_id and

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

3743: open cur_mtq_details_mon ;
3744: fetch cur_mtq_details_mon into rec_mtq_details_mon;
3745: if cur_mtq_details_mon%notfound then
3746: close cur_mtq_details_mon;
3747: --If the details are not available in msc_operation_networks then
3748: --get it from msc_routing_operations.
3749: open cur_mtq_details_mro;
3750: fetch cur_mtq_details_mro into rec_mtq_details_mro;
3751: if cur_mtq_details_mro%notfound then

Line 3917: from msc_operation_networks

3913: select dependency_type,
3914: minimum_transfer_qty,
3915: minimum_time_offset,
3916: maximum_time_offset
3917: from msc_operation_networks
3918: where plan_id = p_plan_id and
3919: sr_instance_id = p_sr_instance_id and
3920: routing_sequence_id = p_routing_seq_id and
3921: from_op_seq_id = p_operation_seq_id and

Line 3986: from msc_operation_networks

3982: select distinct dependency_type,
3983: minimum_transfer_qty,
3984: minimum_time_offset,
3985: maximum_time_offset
3986: from msc_operation_networks
3987: where plan_id = p_plan_id
3988: and sr_instance_id = p_inst_id
3989: and routing_sequence_id = p_routing_seq_id
3990: and transition_type = 1