APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1985: FROM bom_operation_sequences bos, bom_operational_routings bor

1981: WHERE bill_sequence_id = g_rev_comp_unexp_rec.bill_sequence_id;
1982:
1983: CURSOR CheckRouting IS
1984: SELECT 'x'
1985: FROM bom_operation_sequences bos, bom_operational_routings bor
1986: WHERE bor.common_routing_sequence_id = bos.routing_sequence_id
1987: AND bor.organization_id = g_rev_comp_unexp_rec.organization_id
1988: AND bor.assembly_item_id = g_rev_comp_unexp_rec.revised_item_id
1989: AND nvl(bor.alternate_routing_designator,

Line 2048: /* bom_operational_routings bor,

2044:
2045: CURSOR Valid_Op_Seq (p_eco_for_production NUMBER) IS
2046: SELECT 'Valid' valid_op_seq
2047: FROM
2048: /* bom_operational_routings bor,
2049: bom_operation_sequences bos
2050: WHERE bor.assembly_item_id =
2051: g_rev_comp_Unexp_rec.revised_item_id
2052: AND bor.organization_id =

Line 2063: from bom_operational_routings

2059: WHERE
2060: bos.routing_sequence_id =
2061: (
2062: select common_routing_sequence_id
2063: from bom_operational_routings
2064: where assembly_item_id = g_rev_comp_Unexp_rec.revised_item_id
2065: and organization_id = g_rev_comp_Unexp_rec.organization_id
2066: and nvl(alternate_routing_designator,
2067: nvl(g_rev_component_rec.alternate_bom_code, 'NONE')) =

Line 2075: from bom_operational_routings bor2

2071: and (alternate_routing_designator =
2072: g_rev_component_rec.alternate_bom_code
2073: or not exists
2074: (select null
2075: from bom_operational_routings bor2
2076: where bor2.assembly_item_id =
2077: g_rev_comp_Unexp_rec.revised_item_id
2078: and bor2.organization_id = g_rev_comp_Unexp_rec.organization_id
2079: and bor2.alternate_routing_designator =

Line 2460: FROM BOM_OPERATION_SEQUENCES bos, BOM_OPERATIONAL_ROUTINGS bor, BOM_BILL_OF_MATERIALS bom

2456:
2457: Cursor valid_op_seq(p_bill_seq_id NUMBER)
2458: IS
2459: SELECT 1
2460: FROM BOM_OPERATION_SEQUENCES bos, BOM_OPERATIONAL_ROUTINGS bor, BOM_BILL_OF_MATERIALS bom
2461: WHERE (bor.routing_sequence_id = bos.routing_sequence_id
2462: AND bor.assembly_item_id = bom.assembly_item_id
2463: AND bor.organization_id = bom.organization_id
2464: AND nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')

Line 2575: , BOM_OPERATIONAL_ROUTINGS bor

2571: IS
2572:
2573: SELECT 'Rev Item is only Eco for altenate routing'
2574: FROM ENG_REVISED_ITEMS eri
2575: , BOM_OPERATIONAL_ROUTINGS bor
2576: WHERE bor.alternate_routing_designator IS NOT NULL
2577: AND eri.routing_sequence_id = bor.routing_sequence_id(+)
2578: AND eri.routing_sequence_id IS NOT NULL
2579: AND eri.bill_sequence_id IS NULL