APPS.ENG_VALIDATE_SUB_COMPONENT dependencies on BOM_INVENTORY_COMPONENTS

Line 118: bom_inventory_components bic,

114: l_rec_CII,
115: l_rec_ID,
116: l_parent_BIT
117: FROM mtl_system_items msi,
118: bom_inventory_components bic,
119: bom_bill_of_materials bbom
120: WHERE msi.inventory_item_id = bbom.assembly_item_id
121: AND msi.organization_id = bbom.organization_id
122: AND bic.component_sequence_id =

Line 429: bom_inventory_components rev_comp

425:
426: SELECT 1
427: INTO l_dummy
428: FROM bom_substitute_components sub_comp,
429: bom_inventory_components rev_comp
430: WHERE sub_comp.component_sequence_id =
431: p_Sub_Comp_Unexp_Rec.Component_Sequence_Id
432: AND sub_comp.Substitute_Component_Id =
433: p_Sub_Comp_Unexp_Rec.Substitute_Component_Id

Line 689: FROM bom_inventory_components

685: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
686:
687: CURSOR c_GetComponent IS
688: SELECT revised_item_sequence_id
689: FROM bom_inventory_components
690: WHERE component_item_id = p_sub_comp_unexp_rec.component_item_id
691: AND operation_seq_num = p_sub_component_rec.operation_sequence_number
692: AND effectivity_date = p_sub_component_rec.start_effective_date
693: AND bill_sequence_id = p_sub_comp_unexp_rec.bill_sequence_id;