APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1977: FROM bom_operation_sequences bos, bom_operational_routings bor

1973: WHERE bill_sequence_id = g_rev_comp_unexp_rec.bill_sequence_id;
1974:
1975: CURSOR CheckRouting IS
1976: SELECT 'x'
1977: FROM bom_operation_sequences bos, bom_operational_routings bor
1978: WHERE bor.common_routing_sequence_id = bos.routing_sequence_id
1979: AND bor.organization_id = g_rev_comp_unexp_rec.organization_id
1980: AND bor.assembly_item_id = g_rev_comp_unexp_rec.revised_item_id
1981: AND nvl(bor.alternate_routing_designator,

Line 2040: /* bom_operational_routings bor,

2036:
2037: CURSOR Valid_Op_Seq (p_eco_for_production NUMBER) IS
2038: SELECT 'Valid' valid_op_seq
2039: FROM
2040: /* bom_operational_routings bor,
2041: bom_operation_sequences bos
2042: WHERE bor.assembly_item_id =
2043: g_rev_comp_Unexp_rec.revised_item_id
2044: AND bor.organization_id =

Line 2055: from bom_operational_routings

2051: WHERE
2052: bos.routing_sequence_id =
2053: (
2054: select common_routing_sequence_id
2055: from bom_operational_routings
2056: where assembly_item_id = g_rev_comp_Unexp_rec.revised_item_id
2057: and organization_id = g_rev_comp_Unexp_rec.organization_id
2058: and nvl(alternate_routing_designator,
2059: nvl(g_rev_component_rec.alternate_bom_code, 'NONE')) =

Line 2067: from bom_operational_routings bor2

2063: and (alternate_routing_designator =
2064: g_rev_component_rec.alternate_bom_code
2065: or not exists
2066: (select null
2067: from bom_operational_routings bor2
2068: where bor2.assembly_item_id =
2069: g_rev_comp_Unexp_rec.revised_item_id
2070: and bor2.organization_id = g_rev_comp_Unexp_rec.organization_id
2071: and bor2.alternate_routing_designator =

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

2448:
2449: Cursor valid_op_seq(p_bill_seq_id NUMBER)
2450: IS
2451: SELECT 1
2452: FROM BOM_OPERATION_SEQUENCES bos, BOM_OPERATIONAL_ROUTINGS bor, BOM_BILL_OF_MATERIALS bom
2453: WHERE (bor.routing_sequence_id = bos.routing_sequence_id
2454: AND bor.assembly_item_id = bom.assembly_item_id
2455: AND bor.organization_id = bom.organization_id
2456: AND nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')

Line 2567: , BOM_OPERATIONAL_ROUTINGS bor

2563: IS
2564:
2565: SELECT 'Rev Item is only Eco for altenate routing'
2566: FROM ENG_REVISED_ITEMS eri
2567: , BOM_OPERATIONAL_ROUTINGS bor
2568: WHERE bor.alternate_routing_designator IS NOT NULL
2569: AND eri.routing_sequence_id = bor.routing_sequence_id(+)
2570: AND eri.routing_sequence_id IS NOT NULL
2571: AND eri.bill_sequence_id IS NULL