APPS.EGO_UI_ITEM_PUB dependencies on MTL_ITEM_CATEGORIES

Line 2248: from mtl_item_categories a , mtl_system_items_b b

2244: BEGIN
2245: IF (P_CATEGORY_ID <> -1) THEN
2246: IF(P_ITEM_TYPE IS NOT NULL) THEN
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

Line 2264: from mtl_item_categories a , mtl_system_items_b b

2260: and a.organization_id = b.organization_id
2261: and b.eng_item_flag = P_ITEM_TYPE;
2262: ELSE
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

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