DBA Data[Home] [Help]

APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on MTL_ITEM_UOMS_VIEW

Line 508: from mtl_item_uoms_view

504: if (p_PRICING_ATTR_rec.product_attribute_context = 'ITEM') THEN
505: if (p_PRICING_ATTR_rec.product_attribute = 'PRICING_ATTRIBUTE1') THEN
506: begin
507: select 'VALID' INTO l_dummy
508: from mtl_item_uoms_view
509: where uom_code = p_PRICING_ATTR_rec.product_uom_code
510: and organization_id = fnd_profile.value('QP_ORGANIZATION_ID')
511: and inventory_item_id = p_PRICING_ATTR_rec.product_attr_value
512: and rownum = 1;