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.WSM_JOBCOPIES_PVT dependencies on BOM_OPERATION_SEQUENCES

Line 382: FROM BOM_OPERATION_SEQUENCES BOS,

378: BOS.attribute14,
379: BOS.attribute15,
380: BOS.original_system_reference,
381: BOS.lowest_acceptable_yield --mes
382: FROM BOM_OPERATION_SEQUENCES BOS,
383: BOM_STANDARD_OPERATIONS BSO,
384: BOM_DEPARTMENTS BD
385: WHERE BOS.routing_sequence_id = p_common_rtg_seq_id
386: AND p_rtg_rev_date between BOS.effectivity_date and nvl(BOS.disable_date, p_rtg_rev_date+1)

Line 416: bom_operation_sequences where routing_sequence_id = p_common_rtg_seq_id);

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
419: select bos1.operation_sequence_id new_op_seq_id,
420: bos2.operation_sequence_id old_op_seq_id

Line 421: from BOM_OPERATION_SEQUENCES BOS1,

417:
418: CURSOR C_eff_opseq_id IS
419: select bos1.operation_sequence_id new_op_seq_id,
420: bos2.operation_sequence_id old_op_seq_id
421: from BOM_OPERATION_SEQUENCES BOS1,
422: BOM_OPERATION_SEQUENCES BOS2
423: Where BOS1.routing_sequence_id = p_common_rtg_seq_id
424: AND BOS2.routing_sequence_id = p_common_rtg_seq_id
425: AND (p_rtg_rev_date < BOS2.effectivity_date OR

Line 422: BOM_OPERATION_SEQUENCES BOS2

418: CURSOR C_eff_opseq_id IS
419: select bos1.operation_sequence_id new_op_seq_id,
420: bos2.operation_sequence_id old_op_seq_id
421: from BOM_OPERATION_SEQUENCES BOS1,
422: BOM_OPERATION_SEQUENCES BOS2
423: Where BOS1.routing_sequence_id = p_common_rtg_seq_id
424: AND BOS2.routing_sequence_id = p_common_rtg_seq_id
425: AND (p_rtg_rev_date < BOS2.effectivity_date OR
426: p_rtg_rev_date >= nvl(BOS2.disable_date, p_rtg_rev_date-1))

Line 1048: bom_operation_sequences bos

1044: UPDATE wip_operations wo
1045: SET wo.wsm_op_seq_num =
1046: (SELECT distinct(bos.operation_seq_num)
1047: FROM wip_operations wo1,
1048: bom_operation_sequences bos
1049: WHERE wo1.wip_entity_id = p_wip_entity_id
1050: AND wo1.wsm_op_seq_num IS NULL
1051: AND wo1.operation_sequence_id = bos.operation_sequence_id
1052: AND bos.routing_sequence_id = p_common_rtg_seq_id

Line 2174: BOM_OPERATION_SEQUENCES BOS

2170: a.attribute15,
2171: a.original_system_reference
2172: FROM BOM_INVENTORY_COMPONENTS A,
2173: MTL_SYSTEM_ITEMS C,
2174: BOM_OPERATION_SEQUENCES BOS
2175: WHERE a.bill_sequence_id = p_common_bill_seq_id
2176: AND a.component_item_id = c.inventory_item_id
2177: AND c.organization_id = p_org_id
2178: AND BOS.routing_sequence_id = p_common_rtg_seq_id

Line 2686: bom_operation_sequences bos

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
2690: is null

Line 3345: BOM_OPERATION_SEQUENCES BOS,

3341: FROM --MTL_UOM_CONVERSIONS CON,
3342: BOM_RESOURCES BR,
3343: BOM_OPERATION_RESOURCES BOR,
3344: BOM_DEPARTMENT_RESOURCES BDR1,
3345: BOM_OPERATION_SEQUENCES BOS,
3346: BOM_OPERATIONAL_ROUTINGS BRTG,
3347: WSM_COPY_REQUIREMENT_OPS WCRO,
3348: MTL_SYSTEM_ITEMS MSI --BUG 7598223
3349: WHERE wcro.wip_entity_id=p_wip_entity_id