APPS.WSM_JOBCOPIES_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 2575: FROM BOM_OPERATIONAL_ROUTINGS

2571:
2572: BEGIN
2573: SELECT common_routing_sequence_id
2574: INTO l_phantom_rtg_seq_id
2575: FROM BOM_OPERATIONAL_ROUTINGS
2576: WHERE assembly_item_id = t_comp_details(l_first_level_comps_ctr).component_item_id
2577: AND organization_id = p_org_id
2578: AND alternate_routing_designator is null
2579: AND cfm_routing_flag = 3;

Line 2684: FROM bom_operational_routings bor,

2680: AND be.group_id=l_phantom_expl_group_id --l_explosion_group_id
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

Line 3346: BOM_OPERATIONAL_ROUTINGS BRTG,

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
3350: AND wcro.organization_id=p_org_id

Line 3640: from BOM_OPERATIONAL_ROUTINGS

3636:
3637: l_stmt_num := 320;
3638: --R12:Serial Support:
3639: select SERIALIZATION_START_OP into l_serial_start_op
3640: from BOM_OPERATIONAL_ROUTINGS
3641: where ROUTING_SEQUENCE_ID = p_common_rtg_seq_id;
3642:
3643: IF p_insert_wip = 1 THEN
3644: select nvl(OP_SEQ_NUM_INCREMENT, 10)