88: BIC.COMPONENT_ITEM_ID,
89: MSIK.CONCATENATED_SEGMENTS,
90: MSIK.DESCRIPTION
91: FROM MTL_SYSTEM_ITEMS_KFV MSIK,
92: BOM_INVENTORY_COMPONENTS BIC
93: WHERE BIC.COMPONENT_SEQUENCE_ID = ent_comp_seq_id
94: AND MSIK.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
95: AND MSIK.ORGANIZATION_ID = org_id
96: AND NOT EXISTS (
461: BIC.COMPONENT_ITEM_ID,
462: MSIK.CONCATENATED_SEGMENTS,
463: MSIK.DESCRIPTION
464: FROM MTL_SYSTEM_ITEMS_KFV MSIK,
465: BOM_INVENTORY_COMPONENTS BIC
466: WHERE BIC.COMPONENT_SEQUENCE_ID = ent_comp_seq_id
467: AND MSIK.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
468: AND MSIK.ORGANIZATION_ID = org_id
469: AND NOT EXISTS (