APPS.EGO_ITEM_PUB dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 3711: from mtl_category_set_valid_cats

3707: select count(*) into l_total_count
3708: from mtl_item_categories a
3709: where category_id in (
3710: select category_id
3711: from mtl_category_set_valid_cats
3712: start with category_id = P_CATEGORY_ID
3713: and category_set_id = P_CATEGORY_SET_ID --Corrected the connect clause in count query
3714: connect by prior category_id = parent_category_id
3715: and category_set_id = P_CATEGORY_SET_ID)

Line 3741: FROM MTL_CATEGORY_SET_VALID_CATS IC

3737: (p_category_set_id IN NUMBER,
3738: p_category_id IN NUMBER ) IS
3739: SELECT IC.CATEGORY_ID,
3740: IC.PARENT_CATEGORY_ID
3741: FROM MTL_CATEGORY_SET_VALID_CATS IC
3742: START WITH CATEGORY_ID = p_category_id --3030474
3743: AND CATEGORY_SET_ID = p_category_set_id
3744: CONNECT BY PRIOR PARENT_CATEGORY_ID = CATEGORY_ID
3745: AND CATEGORY_SET_ID = p_category_set_id;