APPS.WIP_JSI_VALIDATOR dependencies on WIP_RESERVATIONS_V

Line 722: from wip_reservations_v

718: raise fnd_api.g_exc_unexpected_error;
719: else
720: select sum(primary_quantity), count(*)
721: into l_reserved_qty, l_reservation_count
722: from wip_reservations_v
723: where wip_entity_id = wjsi_row.wip_entity_id
724: and organization_id = wjsi_row.organization_id;
725: if(l_reservation_count > 0 and
726: wjsi_row.start_quantity < l_reserved_qty) then

Line 867: FROM WIP_RESERVATIONS_V

863: l_return_status VARCHAR2(1);
864:
865: CURSOR CHECK_SO_LINK IS
866: SELECT NVL(SUM(PRIMARY_QUANTITY),0)
867: FROM WIP_RESERVATIONS_V
868: WHERE WIP_ENTITY_ID = wjsi_row.Wip_Entity_Id
869: AND INVENTORY_ITEM_ID = nvl(wjsi_row.primary_item_id,l_Primary_Item_Id )
870: AND ORGANIZATION_ID = wjsi_row.Organization_Id;
871: