APPS.WIP_JSI_VALIDATOR dependencies on WIP_RESERVATIONS_V

Line 727: from wip_reservations_v

723: raise fnd_api.g_exc_unexpected_error;
724: else
725: select sum(primary_quantity), count(*)
726: into l_reserved_qty, l_reservation_count
727: from wip_reservations_v
728: where wip_entity_id = wjsi_row.wip_entity_id
729: and organization_id = wjsi_row.organization_id;
730: if(l_reservation_count > 0 and
731: wjsi_row.start_quantity < l_reserved_qty) then

Line 872: FROM WIP_RESERVATIONS_V

868: l_return_status VARCHAR2(1);
869:
870: CURSOR CHECK_SO_LINK IS
871: SELECT NVL(SUM(PRIMARY_QUANTITY),0)
872: FROM WIP_RESERVATIONS_V
873: WHERE WIP_ENTITY_ID = wjsi_row.Wip_Entity_Id
874: AND INVENTORY_ITEM_ID = nvl(wjsi_row.primary_item_id,l_Primary_Item_Id )
875: AND ORGANIZATION_ID = wjsi_row.Organization_Id;
876: