DBA Data[Home] [Help]

APPS.QPR_SR_UTIL dependencies on QPR_UOM_CONVERSIONS

Line 660: from qpr_uom_conversions

656: begin
657: select conv_rate into l_conv_rate
658: from (
659: select 1/(nvl(conversion_rate, 1) ) conv_rate
660: from qpr_uom_conversions
661: where from_uom_code = p_from_uom_code
662: and to_uom_code = p_to_uom_code
663: and instance_id = p_instance_id
664: and item_key in (to_char(p_item_id), '0')

Line 673: from qpr_uom_conversions

669: begin
670: select conv_rate into l_conv_rate
671: from(
672: select (nvl(conversion_rate, 1) ) conv_rate
673: from qpr_uom_conversions
674: where from_uom_code = p_to_uom_code
675: and to_uom_code = p_from_uom_code
676: and instance_id = p_instance_id
677: and item_key in (to_char(p_item_id), '0')