DBA Data[Home] [Help]

APPS.PO_REQIMP_PKG dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 84: mtl_uom_class_conversions.conversion_rate%TYPE,

80: mtl_uom_conversions.conversion_rate%TYPE,
81: x_to_rate IN
82: mtl_uom_conversions.conversion_rate%TYPE,
83: x_class_rate IN
84: mtl_uom_class_conversions.conversion_rate%TYPE,
85: x_unit_price IN OUT NOCOPY
86: po_requisitions_interface.unit_price%TYPE
87: )
88: IS

Line 123: mtl_uom_class_conversions.conversion_rate%TYPE)

119: mtl_uom_conversions.uom_class%TYPE,
120: x_from_class IN
121: mtl_uom_conversions.uom_class%TYPE,
122: x_class_rate OUT NOCOPY
123: mtl_uom_class_conversions.conversion_rate%TYPE)
124: IS
125: BEGIN
126:
127: SELECT nvl(conversion_rate,0)

Line 129: FROM mtl_uom_class_conversions

125: BEGIN
126:
127: SELECT nvl(conversion_rate,0)
128: INTO x_class_rate
129: FROM mtl_uom_class_conversions
130: WHERE inventory_item_id = x_item_id
131: AND to_uom_class = x_item_uom_class
132: AND from_uom_class = x_from_class ;
133:

Line 156: l_class_rate mtl_uom_class_conversions.conversion_rate%TYPE;

152: l_quantity po_requisitions_interface.quantity%TYPE;
153: l_unit_price po_requisitions_interface.unit_price%TYPE;
154: l_from_rate mtl_uom_conversions.conversion_rate%TYPE;
155: l_to_rate mtl_uom_conversions.conversion_rate%TYPE;
156: l_class_rate mtl_uom_class_conversions.conversion_rate%TYPE;
157: l_from_class mtl_uom_conversions.uom_class%TYPE;
158: l_item_uom_class mtl_uom_conversions.uom_class%TYPE;
159: l_dummy char(1);
160: