[Home] [Help]
123: FROM dual
124: WHERE
125: EXISTS
126: (SELECT 1
127: FROM qp_list_attributes_v attr,pv_partner_program_b prg
128: WHERE prg.program_id = p_program_id
129: AND attr.PRODUCT_ATTR_VALUE = to_char(prg.inventory_item_id)
130: AND attr.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
131: AND attr.PRODUCT_ATTRIBUTE ='PRICING_ATTRIBUTE1'