APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_REFERENCE_DESIGNATORS

Line 3053: FROM bom_reference_designators

3049:
3050:
3051: CURSOR c_RefDesgs IS
3052: SELECT count(component_sequence_id) number_of_desgs
3053: FROM bom_reference_designators
3054: WHERE component_sequence_id =
3055: p_rev_comp_unexp_rec.component_sequence_id;
3056:
3057: CURSOR c_NewBill IS

Line 3199: select count(*) into l_total_rds from bom_reference_designators

3195: -- Basis type cannot be Lot if there are existing Reference Desigantors.
3196: IF (p_rev_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
3197:
3198: If(p_rev_component_rec.Basis_type = 2) THEN
3199: select count(*) into l_total_rds from bom_reference_designators
3200: where nvl(p_rev_component_rec.acd_type,1) <>3 and component_sequence_id=p_Rev_Comp_Unexp_Rec.component_sequence_id;
3201: IF(l_total_rds <>0) THEN
3202: l_Token_Tbl(1).Token_Name := 'REVISED_COMPONENT_NAME';
3203: l_Token_Tbl(1).Token_Value := p_rev_component_rec.component_item_name;