APPS.MSC_GET_NAME dependencies on MSC_ROUTING_OPERATIONS

Line 2634: msc_routing_operations mro, msc_bom_components assy

2630: p_arg_1 number ) return varchar2 is
2631: cursor c_op_seq_num is
2632: select distinct mro.operation_seq_num
2633: from msc_operation_components moc,
2634: msc_routing_operations mro, msc_bom_components assy
2635: where moc.plan_id(+)= -1
2636: and moc.component_sequence_id(+)= assy.component_sequence_id
2637: and moc.sr_instance_id(+)= assy.sr_instance_id
2638: and moc.bill_sequence_id(+)= assy.bill_sequence_id

Line 4174: from msc_routing_operations

4170: from_item_id = p_item_id;
4171:
4172: cursor cur_mtq_details_mro is
4173: select minimum_transfer_quantity
4174: from msc_routing_operations
4175: where plan_id = p_plan_id and
4176: sr_instance_id = p_sr_instance_id and
4177: routing_sequence_id = p_routing_seq_id and
4178: operation_sequence_id = p_operation_seq_id;

Line 4205: --get it from msc_routing_operations.

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

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

4230: else
4231: return null;
4232: end if;
4233: else
4234: --Always get it from msc_routing_operations table.
4235: open cur_mtq_details_mro;
4236: fetch cur_mtq_details_mro into rec_mtq_details_mro;
4237: if cur_mtq_details_mro%notfound then
4238: close cur_mtq_details_mro;

Line 4335: from msc_routing_operations

4331: return number is
4332:
4333: cursor cur_routing_op_seq_num is
4334: select operation_sequence_id
4335: from msc_routing_operations
4336: where plan_id = p_plan_id
4337: and sr_instance_id = p_sr_instance_id
4338: and routing_sequence_id = p_routing_seq_id
4339: and operation_seq_num = p_op_seq_num;

Line 4877: from msc_routing_operations

4873: p_sr_instance_id number,
4874: p_routing_sequence_id number,
4875: p_op_seq_id number) is
4876: select standard_operation_code
4877: from msc_routing_operations
4878: where plan_id = p_plan_id
4879: and sr_instance_id = p_sr_instance_id
4880: and routing_sequence_id = p_routing_sequence_id
4881: and operation_sequence_id = p_op_seq_id;

Line 5658: from msc_routing_operations mro

5654: p_routing_seq_id number, p_op_seq_id number) return varchar2 is
5655:
5656: cursor c_op_desc_cur is
5657: select mro.operation_description
5658: from msc_routing_operations mro
5659: where mro.plan_id = p_plan_id
5660: and mro.sr_instance_id = p_sr_instance_id
5661: and mro.routing_sequence_id = nvl(p_routing_seq_id, mro.routing_sequence_id)
5662: and mro.operation_sequence_id = p_op_seq_id;