APPS.WSM_JOBCOPIES_PVT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 2806: FROM BOM_OPERATIONAL_ROUTINGS

2802:
2803: BEGIN
2804: SELECT common_routing_sequence_id
2805: INTO l_phantom_rtg_seq_id
2806: FROM BOM_OPERATIONAL_ROUTINGS
2807: WHERE assembly_item_id = t_comp_details(l_first_level_comps_ctr).component_item_id
2808: AND organization_id = p_org_id
2809: AND alternate_routing_designator is null
2810: AND cfm_routing_flag = 3;

Line 2915: FROM bom_operational_routings bor,

2911: AND be.group_id=l_phantom_expl_group_id --l_explosion_group_id
2912: AND ((be.operation_seq_num=1)
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

Line 3577: BOM_OPERATIONAL_ROUTINGS BRTG,

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

Line 3871: from BOM_OPERATIONAL_ROUTINGS

3867:
3868: l_stmt_num := 320;
3869: --R12:Serial Support:
3870: select SERIALIZATION_START_OP into l_serial_start_op
3871: from BOM_OPERATIONAL_ROUTINGS
3872: where ROUTING_SEQUENCE_ID = p_common_rtg_seq_id;
3873:
3874: IF p_insert_wip = 1 THEN
3875: select nvl(OP_SEQ_NUM_INCREMENT, 10)