DBA Data[Home] [Help]

APPS.QP_BULK_VALUE_TO_ID dependencies on MTL_SYSTEM_ITEMS_VL

Line 364: FROM mtl_system_items_vl a, qp_interface_pricing_attribs c

360: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
361: (SELECT a.inventory_item_id,
362: DECODE(a.inventory_item_id, NULL, null, 'P'),
363: DECODE(a.inventory_item_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)
364: FROM mtl_system_items_vl a, qp_interface_pricing_attribs c
365: WHERE (c.product_attr_value IS NULL and
366: a.concatenated_segments= c.product_attr_val_disp
367: OR c.product_attr_value IS NOT NULL and
368: a.inventory_item_id = c.product_attr_value)