APPS.EGO_UI_ITEM_PUB dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 2251: from mtl_category_set_valid_cats

2247: select count(*) into l_total_count
2248: from mtl_item_categories a , mtl_system_items_b b
2249: where category_id in (
2250: select category_id
2251: from mtl_category_set_valid_cats
2252: start with category_id = P_CATEGORY_ID
2253: and category_set_id = P_CATEGORY_SET_ID --Corrected the connect clause in count query
2254: connect by prior category_id = parent_category_id
2255: and category_set_id = P_CATEGORY_SET_ID

Line 2267: from mtl_category_set_valid_cats

2263: select count(*) into l_total_count
2264: from mtl_item_categories a , mtl_system_items_b b
2265: where category_id in (
2266: select category_id
2267: from mtl_category_set_valid_cats
2268: start with category_id = P_CATEGORY_ID
2269: and category_set_id = P_CATEGORY_SET_ID --Corrected the connect clause in count query
2270: connect by prior category_id = parent_category_id
2271: and category_set_id = P_CATEGORY_SET_ID

Line 2281: from mtl_item_categories a , mtl_system_items_b b,mtl_category_set_valid_cats c

2277: END IF;
2278: ELSE
2279: IF(P_ITEM_TYPE IS NOT NULL) THEN
2280: select count(*) into l_total_count
2281: from mtl_item_categories a , mtl_system_items_b b,mtl_category_set_valid_cats c
2282: where a.organization_id = P_ORGANIZATION_ID
2283: and a.category_set_id = P_CATEGORY_SET_ID
2284: and c.category_set_id = P_CATEGORY_SET_ID
2285: and c.category_id = a.category_id

Line 2291: from mtl_item_categories a , mtl_system_items_b b,mtl_category_set_valid_cats c

2287: and a.organization_id = b.organization_id
2288: and b.eng_item_flag = P_ITEM_TYPE;
2289: ELSE
2290: select count(*) into l_total_count
2291: from mtl_item_categories a , mtl_system_items_b b,mtl_category_set_valid_cats c
2292: where a.organization_id = P_ORGANIZATION_ID
2293: and a.category_set_id = P_CATEGORY_SET_ID
2294: and c.category_set_id = P_CATEGORY_SET_ID
2295: and c.category_id = a.category_id

Line 2319: FROM MTL_CATEGORY_SET_VALID_CATS IC

2315: CURSOR get_parent_category_id_csr (p_category_set_id IN NUMBER,
2316: p_category_id IN NUMBER ) IS
2317: SELECT IC.CATEGORY_ID,
2318: IC.PARENT_CATEGORY_ID
2319: FROM MTL_CATEGORY_SET_VALID_CATS IC
2320: START WITH CATEGORY_ID = p_category_id --3030474
2321: AND CATEGORY_SET_ID = p_category_set_id
2322: CONNECT BY PRIOR PARENT_CATEGORY_ID = CATEGORY_ID
2323: AND CATEGORY_SET_ID = p_category_set_id;