DBA Data[Home] [Help]

APPS.QP_BULK_VALUE_TO_ID dependencies on QP_ITEM_CATEGORIES_V

Line 415: FROM qp_item_categories_v a, qp_interface_pricing_attribs c

411: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
412: (SELECT a.category_id,
413: DECODE(a.category_id, NULL, null, 'P'),
414: DECODE(a.category_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)
415: FROM qp_item_categories_v a, qp_interface_pricing_attribs c
416: WHERE (c.product_attr_value IS NULL and
417: a.category_name = c.product_attr_val_disp
418: OR c.product_attr_value IS NOT NULL and
419: a.category_id = c.product_attr_value)