APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_OPERATION_SEQUENCES

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

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

Line 2050: bom_operation_sequences bos

2046: AND NVL(bor.alternate_routing_designator, 'NONE') =
2047: NVL(g_rev_component_rec.alternate_bom_code, 'NONE')
2048: AND bos.routing_sequence_id = bor.common_routing_sequence_id
2049: */
2050: bom_operation_sequences bos
2051: WHERE
2052: bos.routing_sequence_id =
2053: (
2054: select common_routing_sequence_id

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