DBA Data[Home] [Help]

APPS.WMS_ITEM_LOAD dependencies on INV_CONVERT

Line 136: x_available_qty := inv_convert.inv_um_convert (p_inventory_item_id,

132: IF (l_debug = 1) THEN
133: print_debug('Call inv_um_convert to convert the load quantity');
134: END IF;
135: IF (p_uom_code <> p_prim_uom_code) THEN
136: x_available_qty := inv_convert.inv_um_convert (p_inventory_item_id,
137: 5,
138: l_load_prim_quantity,
139: p_prim_uom_code,
140: p_uom_code,

Line 153: inv_convert.inv_um_convert (p_inventory_item_id,

149: BEGIN
150: SELECT SUM(Decode(uom_code,
151: p_uom_code,
152: quantity,
153: inv_convert.inv_um_convert (p_inventory_item_id,
154: 5,
155: quantity,
156: uom_code,
157: p_uom_code,

Line 339: x_available_lot_qty := inv_convert.inv_um_convert (p_inventory_item_id,

335: IF (l_debug = 1) THEN
336: print_debug('Call inv_um_convert to convert the load quantity');
337: END IF;
338: IF (p_uom_code <> p_prim_uom_code) THEN
339: x_available_lot_qty := inv_convert.inv_um_convert (p_inventory_item_id,
340: 5,
341: l_load_prim_quantity,
342: p_prim_uom_code,
343: p_uom_code,

Line 761: inv_convert.inv_um_convert (p_inventory_item_id,

757:
758: -- Convert the item load quantity into the primary quantity if necessary
759: IF (p_uom_code <> l_primary_uom_code) THEN
760: l_primary_load_qty :=
761: inv_convert.inv_um_convert (p_inventory_item_id,
762: 5,
763: p_quantity,
764: p_uom_code,
765: l_primary_uom_code,

Line 964: inv_convert.inv_um_convert (p_inventory_item_id,

960:
961: -- Convert the MO qty available to the primary UOM if necessary
962: IF (l_mo_uom_code <> l_primary_uom_code) THEN
963: l_primary_qty_avail :=
964: inv_convert.inv_um_convert (p_inventory_item_id,
965: 5,
966: l_mo_qty_avail,
967: l_mo_uom_code,
968: l_primary_uom_code,

Line 1040: l_sec_qty_avail := inv_convert.inv_um_convert (

1036: l_primary_qty_avail := l_load_prim_quantity;
1037:
1038: --laks
1039: IF(p_sec_uom_code IS NOT NULL) THEN
1040: l_sec_qty_avail := inv_convert.inv_um_convert (
1041: p_inventory_item_id,
1042: p_lot_number,
1043: p_organization_id,
1044: 5,