APPS.BOM_DEFAULT_BOM_COMPONENT dependencies on BOM_OPERATION_SEQUENCES

Line 46: FROM bom_operation_sequences bos, bom_operational_routings bor

42: WHERE bill_sequence_id = g_rev_comp_unexp_rec.bill_sequence_id;
43:
44: CURSOR CheckRouting IS
45: SELECT 'x'
46: FROM bom_operation_sequences bos, bom_operational_routings bor
47: WHERE bor.common_routing_sequence_id = bos.routing_sequence_id
48: AND bor.organization_id = g_rev_comp_unexp_rec.organization_id
49: AND bor.assembly_item_id = g_rev_comp_unexp_rec.revised_item_id
50: AND nvl(bor.alternate_routing_designator,

Line 56: FROM bom_operation_sequences bos, bom_operational_routings bor

52: nvl(l_alternate_bom_designator, 'NONE');
53:
54: CURSOR CheckPrimaryRouting IS
55: SELECT 'x'
56: FROM bom_operation_sequences bos, bom_operational_routings bor
57: WHERE bor.common_routing_sequence_id = bos.routing_sequence_id
58: AND bor.organization_id = g_rev_comp_unexp_rec.organization_id
59: AND bor.assembly_item_id = g_rev_comp_unexp_rec.revised_item_id;
60: