DBA Data[Home] [Help]

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