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 2685: bom_operation_networks_v bonv,

2681: AND ((be.operation_seq_num=1)
2682: OR (exists
2683: (SELECT 1
2684: FROM bom_operational_routings bor,
2685: bom_operation_networks_v bonv,
2686: bom_operation_sequences bos
2687: WHERE bor.assembly_item_id =
2688: be.assembly_item_id
2689: AND bor.alternate_routing_designator

Line 3366: FROM BOM_OPERATION_NETWORKS_V BON

3362: AND NVL(BOS.operation_type, 1) = 1
3363: AND (bos.operation_sequence_id in
3364: (
3365: (SELECT bon.FROM_op_seq_id
3366: FROM BOM_OPERATION_NETWORKS_V BON
3367: WHERE bon.transition_type=1
3368: AND bon.routing_sequence_id=BRTG.common_routing_sequence_id
3369: )
3370: UNION ALL

Line 3372: FROM BOM_OPERATION_NETWORKS_V BON

3368: AND bon.routing_sequence_id=BRTG.common_routing_sequence_id
3369: )
3370: UNION ALL
3371: (SELECT bon.to_op_seq_id
3372: FROM BOM_OPERATION_NETWORKS_V BON
3373: WHERE bon.transition_type=1
3374: AND bon.routing_sequence_id =
3375: BRTG.common_routing_sequence_id
3376: )