Oracle Fusion - SQL - Item Category - Product Categories - Catalogs

Item Categories =============== SELECT * FROM egp_item_categories c Item Category Assignment ======================== SELECT i.item_number,i.ORGANIZATION_ID,cat.CATEGORY_NAME FROM EGP_SYSTEM_ITEMS_B i ,egp_item_categories c,egp_categories_tl cat where i.INVENTORY_ITEM_ID=c.INVENTORY_ITEM_ID and i.ORGANIZATION_ID=c.ORGANIZATION_ID and c.CATEGORY_ID=cat.CATEGORY_ID and cat.LANGUAGE = 'US' List of Item Categories ======================= SELECT CATEGORY_ID, DESCRIPTION, CATEGORY_NAME, SOURCE_LANG, OBJECT_VERSION_NUMBER FROM EGP_CATEGORIES_TL ECT WHERE LANGUAGE = 'US' order by 3