DBA Data[Home] [Help]

APPS.INV_PHY_INV_LOVS dependencies on INV_CONVERT

Line 882: --bug 8526693 added lot no and org id parameters to invoke inv_convert to honor lot specific conversions

878: FROM mtl_system_items
879: WHERE inventory_item_id = p_inventory_item_id
880: AND organization_id = p_organization_id;
881: -- I assume that the primary_uom_code is always given for an item
882: --bug 8526693 added lot no and org id parameters to invoke inv_convert to honor lot specific conversions
883: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert
884: ( item_id => p_inventory_item_id,
885: lot_number => p_lot_number,
886: organization_id => p_organization_id,

Line 883: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert

879: WHERE inventory_item_id = p_inventory_item_id
880: AND organization_id = p_organization_id;
881: -- I assume that the primary_uom_code is always given for an item
882: --bug 8526693 added lot no and org id parameters to invoke inv_convert to honor lot specific conversions
883: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert
884: ( item_id => p_inventory_item_id,
885: lot_number => p_lot_number,
886: organization_id => p_organization_id,
887: precision => 5,

Line 1100: --bug 8526693 added lot no and org id parameters to invoke inv_convert to honor lot specific conversions

1096: FROM mtl_system_items
1097: WHERE inventory_item_id = p_inventory_item_id
1098: AND organization_id = p_organization_id;
1099: -- I assume that the primary_uom_code is always given for an item
1100: --bug 8526693 added lot no and org id parameters to invoke inv_convert to honor lot specific conversions
1101: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert
1102: ( item_id => p_inventory_item_id,
1103: lot_number => p_lot_number,
1104: organization_id => p_organization_id,

Line 1101: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert

1097: WHERE inventory_item_id = p_inventory_item_id
1098: AND organization_id = p_organization_id;
1099: -- I assume that the primary_uom_code is always given for an item
1100: --bug 8526693 added lot no and org id parameters to invoke inv_convert to honor lot specific conversions
1101: l_tag_qty_at_standard_uom := inv_convert.inv_um_convert
1102: ( item_id => p_inventory_item_id,
1103: lot_number => p_lot_number,
1104: organization_id => p_organization_id,
1105: precision => 5,

Line 2570: , tag_quantity_at_standard_uom = inv_convert.inv_um_convert

2566: UPDATE mtl_physical_inventory_tags
2567: set locator_id = nvl(i.to_locator, l_prev_loctor)
2568: , subinventory = nvl(i.xfr_subinventory_name,l_prev_subinv)
2569: , tag_quantity = i.count_quantity --bug 14778466
2570: , tag_quantity_at_standard_uom = inv_convert.inv_um_convert
2571: ( item_id => inventory_item_id,
2572: lot_number => lot_number,
2573: organization_id => organization_id,
2574: precision => 5,