APPS.BOM_VALIDATE_SUB_COMPONENT dependencies on BOM_INVENTORY_COMPONENTS

Line 157: bom_inventory_components bic,

153: l_rec_ATO_flag,
154: l_rec_optional
155: FROM mtl_system_items msi,
156: mtl_system_items msi2,
157: bom_inventory_components bic,
158: bom_bill_of_materials bbom
159: WHERE msi.inventory_item_id = bbom.assembly_item_id
160: AND msi.organization_id = bbom.organization_id
161: AND msi2.inventory_item_id = bic.component_item_id

Line 601: bom_inventory_components rev_comp

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

Line 968: FROM bom_inventory_components

964: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
965:
966: CURSOR c_GetComponent IS
967: SELECT revised_item_sequence_id
968: FROM bom_inventory_components
969: WHERE component_item_id = p_sub_comp_unexp_rec.component_item_id
970: AND operation_seq_num = p_sub_component_rec.operation_sequence_number
971: AND effectivity_date = p_sub_component_rec.start_effective_date
972: AND bill_sequence_id = p_sub_comp_unexp_rec.bill_sequence_id;