DBA Data[Home] [Help]

APPS.GMD_QM_UOM dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 176: from MTL_LOT_UOM_CLASS_CONVERSIONS

172:
173: Cursor C9 (lot_number_in varchar2, org_id_in number, item_id_in number,
174: from_uom_in varchar2, to_uom_in varchar2) is
175: select conversion_id
176: from MTL_LOT_UOM_CLASS_CONVERSIONS
177: where inventory_item_id = item_id_in
178: and organization_id = org_id_in
179: and lot_number = lot_number_in
180: and from_uom_code = from_uom_in

Line 183: l_conversion_id mtl_lot_uom_class_conversions.conversion_id%TYPE;

179: and lot_number = lot_number_in
180: and from_uom_code = from_uom_in
181: and to_uom_code = to_uom_in;
182:
183: l_conversion_id mtl_lot_uom_class_conversions.conversion_id%TYPE;
184: -- JD changed query above to get exact conversion.
185:
186: -- SCHANDRU INVCONV END
187: