APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_OPERATION_SEQUENCES

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 2049: bom_operation_sequences bos

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 =
2053: g_rev_comp_Unexp_rec.organization_id

Line 2058: bom_operation_sequences bos

2054: AND NVL(bor.alternate_routing_designator, 'NONE') =
2055: NVL(g_rev_component_rec.alternate_bom_code, 'NONE')
2056: AND bos.routing_sequence_id = bor.common_routing_sequence_id
2057: */
2058: bom_operation_sequences bos
2059: WHERE
2060: bos.routing_sequence_id =
2061: (
2062: select common_routing_sequence_id

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')