APPS.MSC_GET_NAME dependencies on MSC_ROUTING_OPERATIONS

Line 2232: msc_routing_operations mro, msc_bom_components assy

2228: p_arg_1 number ) return varchar2 is
2229: cursor c_op_seq_num is
2230: select distinct mro.operation_seq_num
2231: from msc_operation_components moc,
2232: msc_routing_operations mro, msc_bom_components assy
2233: where moc.plan_id(+)= -1
2234: and moc.component_sequence_id(+)= assy.component_sequence_id
2235: and moc.sr_instance_id(+)= assy.sr_instance_id
2236: and moc.bill_sequence_id(+)= assy.bill_sequence_id

Line 3717: from msc_routing_operations

3713: from_item_id = p_item_id;
3714:
3715: cursor cur_mtq_details_mro is
3716: select minimum_transfer_quantity
3717: from msc_routing_operations
3718: where plan_id = p_plan_id and
3719: sr_instance_id = p_sr_instance_id and
3720: routing_sequence_id = p_routing_seq_id and
3721: operation_sequence_id = p_operation_seq_id;

Line 3748: --get it from msc_routing_operations.

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
3752: close cur_mtq_details_mro;

Line 3777: --Always get it from msc_routing_operations table.

3773: else
3774: return null;
3775: end if;
3776: else
3777: --Always get it from msc_routing_operations table.
3778: open cur_mtq_details_mro;
3779: fetch cur_mtq_details_mro into rec_mtq_details_mro;
3780: if cur_mtq_details_mro%notfound then
3781: close cur_mtq_details_mro;

Line 3878: from msc_routing_operations

3874: return number is
3875:
3876: cursor cur_routing_op_seq_num is
3877: select operation_sequence_id
3878: from msc_routing_operations
3879: where plan_id = p_plan_id
3880: and sr_instance_id = p_sr_instance_id
3881: and routing_sequence_id = p_routing_seq_id
3882: and operation_seq_num = p_op_seq_num;

Line 4384: from msc_routing_operations

4380: p_sr_instance_id number,
4381: p_routing_sequence_id number,
4382: p_op_seq_id number) is
4383: select standard_operation_code
4384: from msc_routing_operations
4385: where plan_id = p_plan_id
4386: and sr_instance_id = p_sr_instance_id
4387: and routing_sequence_id = p_routing_sequence_id
4388: and operation_sequence_id = p_op_seq_id;

Line 5086: from msc_routing_operations mro

5082: p_routing_seq_id number, p_op_seq_id number) return varchar2 is
5083:
5084: cursor c_op_desc_cur is
5085: select mro.operation_description
5086: from msc_routing_operations mro
5087: where mro.plan_id = p_plan_id
5088: and mro.sr_instance_id = p_sr_instance_id
5089: and mro.routing_sequence_id = nvl(p_routing_seq_id, mro.routing_sequence_id)
5090: and mro.operation_sequence_id = p_op_seq_id;