DBA Data[Home] [Help]

APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_CATEGORIES_TL

Line 593: FROM icx_cat_categories_tl

589: -- now for each category, we have to either get the category itself (if it is an item category)
590: -- or get the list of item categories under it
591: SELECT distinct rt_category_id
592: BULK COLLECT INTO l_category_ids
593: FROM icx_cat_categories_tl
594: WHERE type = 2
595: AND rt_category_id in (SELECT child_category_id
596: FROM icx_cat_browse_trees
597: START WITH parent_category_id = p_category_ids(i)