eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSMPWROT dependencies on BOM_OPERATION_NETWORKS_V

Line 474: from BOM_OPERATION_NETWORKS_V BONV

470:
471: if (x_first_flag=1) then
472: begin
473: select 0 into x_first_flag
474: from BOM_OPERATION_NETWORKS_V BONV
475: where BONV.routing_sequence_id=p_routing_sequence_id
476: and ((BONV.from_seq_num = 1) or (BONV.to_seq_num=1));
477: exception
478: when no_data_found then

Line 626: bom_operation_networks_v bonv,

622: and ((be.operation_seq_num=1)
623: or (be.operation_seq_num in (
624: select bonv.from_seq_num
625: from bom_operational_routings bor,
626: bom_operation_networks_v bonv,
627: bom_operation_sequences bos
628: where bor.assembly_item_id=be.assembly_item_id
629: and bor.alternate_routing_designator is null
630: and bonv.routing_sequence_id=bor.common_routing_sequence_id

Line 641: bom_operation_networks_v bonv,

637: and bonv.transition_type=1))
638: or (be.operation_seq_num in (
639: select bonv.to_seq_num
640: from bom_operational_routings bor,
641: bom_operation_networks_v bonv,
642: bom_operation_sequences bos
643: where bor.assembly_item_id=be.assembly_item_id
644: and bor.alternate_routing_designator is null
645: and bonv.routing_sequence_id=bor.common_routing_sequence_id

Line 1040: and (bos.operation_sequence_id in ((select bon.from_op_seq_id from bom_operation_sequences bos1, BOM_OPERATION_NETWORKS_V BON

1036: and BRTG.common_routing_sequence_id = BOS.routing_sequence_id
1037: and BOS.effectivity_date <= x_routing_revision_date
1038: and NVL(BOS.operation_type, 1) = 1
1039: and NVL(BOS.disable_date, x_routing_revision_date+ 2) >= x_routing_revision_date
1040: and (bos.operation_sequence_id in ((select bon.from_op_seq_id from bom_operation_sequences bos1, BOM_OPERATION_NETWORKS_V BON
1041: where bon.transition_type=1
1042: and bon.routing_sequence_id=BRTG.common_routing_sequence_id )
1043: UNION ALL
1044: (select bon.to_op_seq_id from BOM_OPERATION_NETWORKS_V BON

Line 1044: (select bon.to_op_seq_id from BOM_OPERATION_NETWORKS_V BON

1040: and (bos.operation_sequence_id in ((select bon.from_op_seq_id from bom_operation_sequences bos1, BOM_OPERATION_NETWORKS_V BON
1041: where bon.transition_type=1
1042: and bon.routing_sequence_id=BRTG.common_routing_sequence_id )
1043: UNION ALL
1044: (select bon.to_op_seq_id from BOM_OPERATION_NETWORKS_V BON
1045: where bon.transition_type=1
1046: and bon.routing_sequence_id=BRTG.common_routing_sequence_id )))
1047: ORDER BY BOS.operation_seq_num;
1048: