APPS.MSC_GET_NAME dependencies on MSC_BOM_COMPONENTS
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