DBA Data[Home] [Help]

APPS.GME_SCALE_BATCH_PVT dependencies on SY_UOMS_MST

Line 204: l_from_uom sy_uoms_mst.um_code%TYPE;

200: l_count NUMBER;
201: l_item_id NUMBER (10);
202: l_scale_factor NUMBER;
203: l_cnt NUMBER := 0;
204: l_from_uom sy_uoms_mst.um_code%TYPE;
205: l_to_uom sy_uoms_mst.um_code%TYPE;
206: l_item_no ic_item_mst.item_no%TYPE;
207: l_routing_scale_factor NUMBER;
208: before_scale_qty NUMBER;

Line 205: l_to_uom sy_uoms_mst.um_code%TYPE;

201: l_item_id NUMBER (10);
202: l_scale_factor NUMBER;
203: l_cnt NUMBER := 0;
204: l_from_uom sy_uoms_mst.um_code%TYPE;
205: l_to_uom sy_uoms_mst.um_code%TYPE;
206: l_item_no ic_item_mst.item_no%TYPE;
207: l_routing_scale_factor NUMBER;
208: before_scale_qty NUMBER;
209: after_scale_qty NUMBER;

Line 1311: l_uom sy_uoms_mst.um_code%TYPE;

1307: FROM mtl_system_items_kfv
1308: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
1309:
1310: l_api_name CONSTANT VARCHAR2 (30) := 'GET_TOTAL_QTY';
1311: l_uom sy_uoms_mst.um_code%TYPE;
1312: l_qty NUMBER := 0;
1313: l_item_id NUMBER;
1314: l_item_no VARCHAR2 (32);
1315: l_from_uom sy_uoms_mst.um_code%TYPE;

Line 1315: l_from_uom sy_uoms_mst.um_code%TYPE;

1311: l_uom sy_uoms_mst.um_code%TYPE;
1312: l_qty NUMBER := 0;
1313: l_item_id NUMBER;
1314: l_item_no VARCHAR2 (32);
1315: l_from_uom sy_uoms_mst.um_code%TYPE;
1316: l_to_uom sy_uoms_mst.um_code%TYPE;
1317: l_rout_um sy_uoms_mst.um_code%TYPE;
1318: x_return_status VARCHAR2 (1);
1319: conversion_failure EXCEPTION;

Line 1316: l_to_uom sy_uoms_mst.um_code%TYPE;

1312: l_qty NUMBER := 0;
1313: l_item_id NUMBER;
1314: l_item_no VARCHAR2 (32);
1315: l_from_uom sy_uoms_mst.um_code%TYPE;
1316: l_to_uom sy_uoms_mst.um_code%TYPE;
1317: l_rout_um sy_uoms_mst.um_code%TYPE;
1318: x_return_status VARCHAR2 (1);
1319: conversion_failure EXCEPTION;
1320: l_plan_wipplan_qty NUMBER := 0;

Line 1317: l_rout_um sy_uoms_mst.um_code%TYPE;

1313: l_item_id NUMBER;
1314: l_item_no VARCHAR2 (32);
1315: l_from_uom sy_uoms_mst.um_code%TYPE;
1316: l_to_uom sy_uoms_mst.um_code%TYPE;
1317: l_rout_um sy_uoms_mst.um_code%TYPE;
1318: x_return_status VARCHAR2 (1);
1319: conversion_failure EXCEPTION;
1320: l_plan_wipplan_qty NUMBER := 0;
1321: l_temp_qty NUMBER;