Posts

Showing posts from 2021

Oracle Fusion : SQL Query to Retrieve Shopping Category Hierarcy

You can use below SQL query to list down all shopping cateogry hierarcy (both browsing and purchasing ones) and description for English and Turkish languages. Please feel free to contact me if you relaize any mistake. SELECT prct.CATEGORY_NAME PARENT_CATEGORY_NAME_TR , prce.CATEGORY_NAME PARENT_CATEGORY_NAME_US , pch.PURCHASING_CAT_FLAG , CASE WHEN pch.PURCHASING_CAT_FLAG = 'Y' THEN ( SELECT ect.CATEGORY_NAME FROM EGP_CATEGORIES_TL ect WHERE pch.child_category_id = ect.category_id AND ect.language = 'TR' ) ELSE ( SELECT prct.CATEGORY_NAME FROM POR_BROWSE