APPS.WSMPWROT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 541: FROM BOM_OPERATIONAL_ROUTINGS

537: l_stmt_num := 51;
538:
539: BEGIN
540: SELECT common_routing_sequence_id into x_routing_sequence_id
541: FROM BOM_OPERATIONAL_ROUTINGS
542: WHERE assembly_item_id = t_comp_details(i).component_item_id
543: AND organization_id = p_organization_id
544: AND alternate_routing_designator is null
545: AND cfm_routing_flag = 3;

Line 625: from bom_operational_routings bor,

621: and be.group_id=WSMPWROT.EXPLOSION_GROUP_ID
622: and ((be.operation_seq_num=1)
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

Line 640: from bom_operational_routings bor,

636: and NVL(BOS.operation_type, 1) = 1
637: and bonv.transition_type=1))
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

Line 1016: BOM_OPERATIONAL_ROUTINGS BRTG,

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
1020: BRTG.organization_id = p_organization_id