DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on QP_ITEM_CATEGORIES_V

Line 3138: FROM qp_item_categories_v

3134: ELSIF (p_item_category_name is not null) THEN
3135: BEGIN
3136: SELECT distinct category_id
3137: INTO x_prod_attr_value
3138: FROM qp_item_categories_v
3139: WHERE category_name = p_item_category_name;
3140: EXCEPTION
3141: WHEN NO_DATA_FOUND THEN
3142: x_prod_attr_value := 'CATEGORY_LOOKUP_FAILED';