DBA Data[Home] [Help]

APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_BROWSE_TREES

Line 596: FROM icx_cat_browse_trees

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)
598: CONNECT BY NOCYCLE PRIOR child_category_id = parent_category_id
599: UNION ALL
600: SELECT p_category_ids(i)