DBA Data[Home] [Help]

APPS.INV_COMINGLING_UTILS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 152: from mtl_onhand_quantities_detail

148: --Changing the count(*) to existence for performance improvement
149: --select
150: --count(*)
151: --into l_moq_count
152: from mtl_onhand_quantities_detail
153: where organization_id = p_organization_id
154: AND inventory_item_id = p_inventory_item_id
155: AND (revision = p_revision
156: OR revision is null and p_revision is null)