EBS QUERY TO FIND PARENT ITEM AND ITS RELATED SKEW ITEMS

The below query will return the skew items(Packaging Item) for a parent item.
Join any of your tables to mtl_system_items_b and it will return the skew items.

SELECT MSIB.SEGMENT1  PARENT_ITEM,

       MSIB1.SEGMENT1 SKEW_ITEM

FROM   MTL_SYSTEM_ITEMS_B MSIB,

       MTL_CATEGORIES_B_KFV B,

       MTL_CATEGORY_SETS_TL C,

       MTL_ITEM_CATEGORIES D,

       MTL_SYSTEM_ITEMS_B MSIB1

WHERE  1 = 1

       AND B.CONCATENATED_SEGMENTS = MSIB.SEGMENT1

       AND C.CATEGORY_SET_NAME LIKE  '%PARENT CODE'

       AND C.LANGUAGE = 'US'

       AND D.CATEGORY_ID = B.CATEGORY_ID

       AND D.CATEGORY_SET_ID = C.CATEGORY_SET_ID

       AND D.ORGANIZATION_ID = MSIB.ORGANIZATION_ID

       AND D.INVENTORY_ITEM_ID <> MSIB.INVENTORY_ITEM_ID

       AND D.INVENTORY_ITEM_ID = MSIB1.INVENTORY_ITEM_ID

       AND D.ORGANIZATION_ID = MSIB1.ORGANIZATION_ID;