DBA Data[Home] [Help]

APPS.QP_BULK_VALUE_TO_ID dependencies on QP_ITEM_CATEGORIES_V

Line 384: FROM qp_item_categories_v a, qp_interface_pricing_attribs c

380: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
381: (SELECT a.category_id,
382: DECODE(a.category_id, NULL, null, 'P'),
383: DECODE(a.category_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)
384: FROM qp_item_categories_v a, qp_interface_pricing_attribs c
385: WHERE (c.product_attr_value IS NULL and
386: a.category_name = c.product_attr_val_disp
387: OR c.product_attr_value IS NOT NULL and
388: a.category_id = c.product_attr_value)