APPS.BOM_VALIDATE_SUB_COMPONENT dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 539: FROM bom_substitute_components sub_comp,

535: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verifying if component is not disable type . . . '); END IF;
536:
537: SELECT count(*)
538: INTO l_dummy
539: FROM bom_substitute_components sub_comp,
540: bom_inventory_components rev_comp
541: WHERE rev_comp.component_sequence_id =
542: p_Sub_Comp_Unexp_Rec.Component_Sequence_Id
543: AND sub_comp.component_sequence_id =

Line 595: FROM BOM_SUBSTITUTE_COMPONENTS

591: and p_Sub_Comp_Unexp_Rec.new_substitute_component_id <> FND_API.G_MISS_NUM
592: and p_sub_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
593:
594: select count(*) into l_temp_var
595: FROM BOM_SUBSTITUTE_COMPONENTS
596: WHERE substitute_component_id = p_Sub_Comp_Unexp_Rec.new_substitute_component_id
597: AND COMPONENT_SEQUENCE_ID = p_Sub_Comp_Unexp_Rec.component_sequence_id
598: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 0) =
599: NVL(DECODE(p_sub_component_rec.acd_type, FND_API.G_MISS_NUM, null, p_sub_component_rec.acd_type), 0) ;