DBA Data[Home] [Help]

APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on MTL_ITEM_UOMS_VIEW

Line 451: from mtl_item_uoms_view

447: if (p_PRICING_ATTR_rec.product_attribute_context = 'ITEM') THEN
448: if (p_PRICING_ATTR_rec.product_attribute = 'PRICING_ATTRIBUTE1') THEN
449: begin
450: select 'VALID' INTO l_dummy
451: from mtl_item_uoms_view
452: where uom_code = p_PRICING_ATTR_rec.product_uom_code
453: and organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
454: and inventory_item_id = p_PRICING_ATTR_rec.product_attr_value
455: and rownum = 1;