194: l_count NUMBER;
195: l_item_id NUMBER (10);
196: l_scale_factor NUMBER;
197: l_cnt NUMBER := 0;
198: l_from_uom sy_uoms_mst.um_code%TYPE;
199: l_to_uom sy_uoms_mst.um_code%TYPE;
200: l_item_no ic_item_mst.item_no%TYPE;
201: l_routing_scale_factor NUMBER;
202: before_scale_qty NUMBER;
195: l_item_id NUMBER (10);
196: l_scale_factor NUMBER;
197: l_cnt NUMBER := 0;
198: l_from_uom sy_uoms_mst.um_code%TYPE;
199: l_to_uom sy_uoms_mst.um_code%TYPE;
200: l_item_no ic_item_mst.item_no%TYPE;
201: l_routing_scale_factor NUMBER;
202: before_scale_qty NUMBER;
203: after_scale_qty NUMBER;
1297: FROM mtl_system_items_kfv
1298: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
1299:
1300: l_api_name CONSTANT VARCHAR2 (30) := 'GET_TOTAL_QTY';
1301: l_uom sy_uoms_mst.um_code%TYPE;
1302: l_qty NUMBER := 0;
1303: l_item_id NUMBER;
1304: l_item_no VARCHAR2 (32);
1305: l_from_uom sy_uoms_mst.um_code%TYPE;
1301: l_uom sy_uoms_mst.um_code%TYPE;
1302: l_qty NUMBER := 0;
1303: l_item_id NUMBER;
1304: l_item_no VARCHAR2 (32);
1305: l_from_uom sy_uoms_mst.um_code%TYPE;
1306: l_to_uom sy_uoms_mst.um_code%TYPE;
1307: l_rout_um sy_uoms_mst.um_code%TYPE;
1308: x_return_status VARCHAR2 (1);
1309: conversion_failure EXCEPTION;
1302: l_qty NUMBER := 0;
1303: l_item_id NUMBER;
1304: l_item_no VARCHAR2 (32);
1305: l_from_uom sy_uoms_mst.um_code%TYPE;
1306: l_to_uom sy_uoms_mst.um_code%TYPE;
1307: l_rout_um sy_uoms_mst.um_code%TYPE;
1308: x_return_status VARCHAR2 (1);
1309: conversion_failure EXCEPTION;
1310: l_plan_wipplan_qty NUMBER := 0;
1303: l_item_id NUMBER;
1304: l_item_no VARCHAR2 (32);
1305: l_from_uom sy_uoms_mst.um_code%TYPE;
1306: l_to_uom sy_uoms_mst.um_code%TYPE;
1307: l_rout_um sy_uoms_mst.um_code%TYPE;
1308: x_return_status VARCHAR2 (1);
1309: conversion_failure EXCEPTION;
1310: l_plan_wipplan_qty NUMBER := 0;
1311: l_temp_qty NUMBER;