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_SEQUENCES

Line 235: FROM BOM_OPERATION_SEQUENCES BOS

231: )
232: AND C.ORGANIZATION_ID = p_organization_id
233: AND ((A.operation_seq_num =
234: (SELECT BOS.operation_seq_num
235: FROM BOM_OPERATION_SEQUENCES BOS
236: WHERE operation_sequence_id = p_operation_sequence_id))
237: OR (x_first_flag = 1 AND A.OPERATION_SEQ_NUM = 1))
238: AND A.EFFECTIVITY_DATE <=p_bom_revision_date
239: AND nvl(A.DISABLE_DATE, p_bom_revision_date + 1) >= p_bom_revision_date -- CHG: BUG2380517 from > to >=

Line 627: bom_operation_sequences bos

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
631: and be.operation_seq_num=bos.operation_seq_num

Line 642: bom_operation_sequences bos

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
646: and be.operation_seq_num=bos.operation_seq_num

Line 1015: BOM_OPERATION_SEQUENCES BOS,

1011: MTL_UOM_CONVERSIONS CON,
1012: BOM_RESOURCES BR,
1013: BOM_OPERATION_RESOURCES BOR,
1014: BOM_DEPARTMENT_RESOURCES BDR1,
1015: BOM_OPERATION_SEQUENCES BOS,
1016: BOM_OPERATIONAL_ROUTINGS BRTG,
1017: WIP_REQUIREMENT_OPERATIONS WRO,
1018: MTL_SYSTEM_ITEMS MSI --BUG 7598223
1019: WHERE

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