DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PVT dependencies on BOM_OPERATION_NETWORKS_V

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: )