APPS.BOM_VALIDATE_SUB_COMPONENT dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 600: FROM bom_substitute_components sub_comp,

596: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verifying if component is not disable type . . . '); END IF;
597:
598: SELECT count(*)
599: INTO l_dummy
600: FROM bom_substitute_components sub_comp,
601: bom_inventory_components rev_comp
602: WHERE rev_comp.component_sequence_id =
603: p_Sub_Comp_Unexp_Rec.Component_Sequence_Id
604: AND sub_comp.component_sequence_id =

Line 656: FROM BOM_SUBSTITUTE_COMPONENTS

652: and p_Sub_Comp_Unexp_Rec.new_substitute_component_id <> FND_API.G_MISS_NUM
653: and p_sub_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
654:
655: select count(*) into l_temp_var
656: FROM BOM_SUBSTITUTE_COMPONENTS
657: WHERE substitute_component_id = p_Sub_Comp_Unexp_Rec.new_substitute_component_id
658: AND COMPONENT_SEQUENCE_ID = p_Sub_Comp_Unexp_Rec.component_sequence_id
659: AND NVL(DECODE(ACD_TYPE, FND_API.G_MISS_NUM, null, acd_type), 0) =
660: NVL(DECODE(p_sub_component_rec.acd_type, FND_API.G_MISS_NUM, null, p_sub_component_rec.acd_type), 0) ;