APPS.CSP_PART_SEARCH_PVT dependencies on CSP_EXCESS_LISTS

Line 1661: from csp_excess_lists

1657: and revision = nvl(p_revision,revision);
1658:
1659: cursor c_excess is
1660: select sum(nvl(excess_quantity,0) - nvl(returned_quantity,0))
1661: from csp_excess_lists
1662: where organization_id = p_organization_id
1663: and nvl(subinventory_code,'-1') = nvl(p_subinventory_code,'-1')
1664: and inventory_item_id = p_inventory_item_id;
1665: