APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_COMPONENTS_B

Line 2317: bom_components_b comp

2313: IS
2314: CURSOR c_Change_Optional IS
2315: SELECT 'Exist' there_Exist
2316: FROM bom_component_operations bco,
2317: bom_components_b comp
2318: WHERE bco.component_sequence_id = comp.component_sequence_id
2319: AND comp.component_sequence_id = g_rev_comp_Unexp_rec.component_sequence_id
2320: AND comp.optional = 1
2321: AND g_rev_component_rec.Optional = 2;

Line 3795: -- in bom_components_b

3791:
3792: /*****************************************************************
3793: -- bug 14351192
3794: -- Verify that the component item does not exist under the same revised item
3795: -- in bom_components_b
3796: --
3797: ******************************************************************/
3798: IF p_rev_component_rec.Transaction_Type = BOM_GLOBALS.G_OPR_CREATE
3799: AND NVL(p_rev_component_rec.acd_type,1) = 1 THEN

Line 3802: from bom_components_b bcb

3798: IF p_rev_component_rec.Transaction_Type = BOM_GLOBALS.G_OPR_CREATE
3799: AND NVL(p_rev_component_rec.acd_type,1) = 1 THEN
3800:
3801: select count(*) into l_RC_Duplicate_Comps
3802: from bom_components_b bcb
3803: where bcb.component_item_id = p_rev_comp_unexp_rec.component_item_id
3804: and bcb.bill_sequence_id = p_rev_comp_unexp_rec.bill_sequence_id
3805: and bcb.operation_seq_num = p_rev_component_rec.Operation_Sequence_Number
3806: and ((bcb.disable_date is null and p_rev_component_rec.disable_date is null) or

Line 3820: from bom_components_b

3816: g_token_tbl(2).token_value := p_rev_component_rec.Operation_Sequence_Number;
3817: g_token_tbl(3).token_name := 'EFFECTIVE_FROM';
3818:
3819: select effectivity_date into g_token_tbl(3).token_value
3820: from bom_components_b
3821: where bill_sequence_id = p_rev_comp_unexp_rec.bill_sequence_id
3822: and component_item_id = p_rev_comp_unexp_rec.component_item_id
3823: and operation_seq_num = p_rev_component_rec.Operation_Sequence_Number
3824: and rownum=1