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 1049: bom_operation_sequences bos

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

Line 2404: BOM_OPERATION_SEQUENCES BOS

2400: a.attribute15,
2401: a.original_system_reference
2402: FROM BOM_INVENTORY_COMPONENTS A,
2403: MTL_SYSTEM_ITEMS C,
2404: BOM_OPERATION_SEQUENCES BOS
2405: WHERE a.bill_sequence_id = p_common_bill_seq_id
2406: AND a.component_item_id = c.inventory_item_id
2407: AND c.organization_id = p_org_id
2408: AND BOS.routing_sequence_id = p_common_rtg_seq_id

Line 2917: bom_operation_sequences bos

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

Line 3576: BOM_OPERATION_SEQUENCES BOS,

3572: FROM --MTL_UOM_CONVERSIONS CON,
3573: BOM_RESOURCES BR,
3574: BOM_OPERATION_RESOURCES BOR,
3575: BOM_DEPARTMENT_RESOURCES BDR1,
3576: BOM_OPERATION_SEQUENCES BOS,
3577: BOM_OPERATIONAL_ROUTINGS BRTG,
3578: WSM_COPY_REQUIREMENT_OPS WCRO,
3579: MTL_SYSTEM_ITEMS MSI --BUG 6495025
3580: WHERE wcro.wip_entity_id=p_wip_entity_id