APPS.BOM_VALIDATE_SUB_COMPONENT dependencies on BOM_INVENTORY_COMPONENTS

Line 145: bom_inventory_components bic,

141: l_rec_CII,
142: l_rec_ID,
143: l_parent_BIT
144: FROM mtl_system_items msi,
145: bom_inventory_components bic,
146: bom_bill_of_materials bbom
147: WHERE msi.inventory_item_id = bbom.assembly_item_id
148: AND msi.organization_id = bbom.organization_id
149: AND bic.component_sequence_id =

Line 540: bom_inventory_components rev_comp

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 =
544: rev_comp.old_component_Sequence_id

Line 907: FROM bom_inventory_components

903: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
904:
905: CURSOR c_GetComponent IS
906: SELECT revised_item_sequence_id
907: FROM bom_inventory_components
908: WHERE component_item_id = p_sub_comp_unexp_rec.component_item_id
909: AND operation_seq_num = p_sub_component_rec.operation_sequence_number
910: AND effectivity_date = p_sub_component_rec.start_effective_date
911: AND bill_sequence_id = p_sub_comp_unexp_rec.bill_sequence_id;