[Home] [Help]
3649: BEGIN
3650: --BugFix 3701796 SQL sum function changed to primary quantity
3651: OPEN x_lot_qty FOR
3652: select lot_number,
3653: SUM(inv_decimals_pub.get_primary_quantity(p_org_id,inventory_item_id,uom_code,Nvl(quantity,0))) primary_quantity
3654: from wms_lpn_contents
3655: where inventory_item_id = p_item_id
3656: and parent_lpn_id = p_lpn_id
3657: and ((revision = p_revision and p_revision is not null) or