DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on INV_DECIMALS_PUB

Line 3374: SUM(inv_decimals_pub.get_primary_quantity(p_org_id,inventory_item_id,uom_code,Nvl(quantity,0))) primary_quantity

3370: BEGIN
3371: --BugFix 3701796 SQL sum function changed to primary quantity
3372: OPEN x_lot_qty FOR
3373: select lot_number,
3374: SUM(inv_decimals_pub.get_primary_quantity(p_org_id,inventory_item_id,uom_code,Nvl(quantity,0))) primary_quantity
3375: from wms_lpn_contents
3376: where inventory_item_id = p_item_id
3377: and parent_lpn_id = p_lpn_id
3378: and ((revision = p_revision and p_revision is not null) or