APPS.EGO_ITEM_PUB dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 3959: from mtl_category_set_valid_cats

3955: select count(*) into l_total_count
3956: from mtl_item_categories a
3957: where category_id in (
3958: select category_id
3959: from mtl_category_set_valid_cats
3960: start with category_id = P_CATEGORY_ID
3961: and category_set_id = P_CATEGORY_SET_ID --Corrected the connect clause in count query
3962: connect by prior category_id = parent_category_id
3963: and category_set_id = P_CATEGORY_SET_ID)

Line 3989: FROM MTL_CATEGORY_SET_VALID_CATS IC

3985: (p_category_set_id IN NUMBER,
3986: p_category_id IN NUMBER ) IS
3987: SELECT IC.CATEGORY_ID,
3988: IC.PARENT_CATEGORY_ID
3989: FROM MTL_CATEGORY_SET_VALID_CATS IC
3990: START WITH CATEGORY_ID = p_category_id --3030474
3991: AND CATEGORY_SET_ID = p_category_set_id
3992: CONNECT BY PRIOR PARENT_CATEGORY_ID = CATEGORY_ID
3993: AND CATEGORY_SET_ID = p_category_set_id;