DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on MTL_UNITS_OF_MEASURE

Line 95: TYPE uom_class_tbl IS TABLE of MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE index by MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

91: l_hook_pricing_uom OE_ORDER_LINES_ALL.PRICING_QUANTITY_UOM%TYPE;
92: l_primary_catch_weight VARCHAR2(1) := NULL;
93: l_secondary_catch_weight VARCHAR2(1) := NULL;
94: l_ref_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
95: TYPE uom_class_tbl IS TABLE of MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE index by MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
96: l_uom_class_tbl uom_class_tbl;
97: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
98:
99: BEGIN

Line 163: FROM MTL_UNITS_OF_MEASURE

159:
160: IF l_hook_pricing_uom IS NULL THEN
161:
162: FOR uom_class_rec IN (SELECT UOM_CODE,UOM_CLASS
163: FROM MTL_UNITS_OF_MEASURE
164: WHERE UOM_CODE in (p_line_rec.order_quantity_uom,l_item_rec.primary_uom_code,l_item_rec.secondary_uom_code) )
165: LOOP
166: l_uom_class_tbl(uom_class_rec.uom_code) := uom_class_rec.uom_class;
167: END LOOP;