DBA Data[Home] [Help]

APPS.GME_SCALE_BATCH_PVT dependencies on SY_UOMS_MST

Line 198: l_from_uom sy_uoms_mst.um_code%TYPE;

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;

Line 199: l_to_uom sy_uoms_mst.um_code%TYPE;

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;

Line 1301: l_uom sy_uoms_mst.um_code%TYPE;

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;

Line 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;

Line 1306: l_to_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;
1310: l_plan_wipplan_qty NUMBER := 0;

Line 1307: l_rout_um sy_uoms_mst.um_code%TYPE;

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;