DBA Data[Home] [Help]

APPS.MSC_GET_NAME dependencies on MSC_BOM_COMPONENTS

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 6265: MSC_BOM_COMPONENTS COMPONENTS,

6261: FROM
6262: MSC_SUPPLIES SUPPLIES,
6263: MSC_FULL_PEGGING PEGGING,
6264: MSC_DEMANDS DEMANDS,
6265: MSC_BOM_COMPONENTS COMPONENTS,
6266: MSC_PLANS PLANS
6267: WHERE
6268: supplies.transaction_id=pegging.transaction_id and
6269: SUPPLIES.SR_INSTANCE_ID = pegging.sr_instance_id and