DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PVT dependencies on BOM_OPERATION_NETWORKS

Line 414: FROM BOM_OPERATION_NETWORKS BON

410: BON.attribute13,
411: BON.attribute14,
412: BON.attribute15,
413: BON.original_system_reference
414: FROM BOM_OPERATION_NETWORKS BON
415: WHERE BON.from_op_seq_id in (select operation_sequence_id from
416: bom_operation_sequences where routing_sequence_id = p_common_rtg_seq_id);
417:
418: CURSOR C_eff_opseq_id IS

Line 2916: bom_operation_networks_v bonv,

2912: AND ((be.operation_seq_num=1)
2913: OR (exists
2914: (SELECT 1
2915: FROM bom_operational_routings bor,
2916: bom_operation_networks_v bonv,
2917: bom_operation_sequences bos
2918: WHERE bor.assembly_item_id =
2919: be.assembly_item_id
2920: AND bor.alternate_routing_designator

Line 3597: FROM BOM_OPERATION_NETWORKS_V BON

3593: AND NVL(BOS.operation_type, 1) = 1
3594: AND (bos.operation_sequence_id in
3595: (
3596: (SELECT bon.FROM_op_seq_id
3597: FROM BOM_OPERATION_NETWORKS_V BON
3598: WHERE bon.transition_type=1
3599: AND bon.routing_sequence_id=BRTG.common_routing_sequence_id
3600: )
3601: UNION ALL

Line 3603: FROM BOM_OPERATION_NETWORKS_V BON

3599: AND bon.routing_sequence_id=BRTG.common_routing_sequence_id
3600: )
3601: UNION ALL
3602: (SELECT bon.to_op_seq_id
3603: FROM BOM_OPERATION_NETWORKS_V BON
3604: WHERE bon.transition_type=1
3605: AND bon.routing_sequence_id =
3606: BRTG.common_routing_sequence_id
3607: )